Varun Blogs

--- Supplier Validation Interco SELECT --POH.SEGMENT1 PO_NUMBER,       --POH.ORG_ID,       --POH.CREATION_DATE PO_CREATION_DT,       POV.segment1 SupplierNumber, pvs.org_id, POV.vendor_id,       POV.VENDOR_NAME SUPPLIER_NAME, pov.enabled_flag, pov.vendor_type_lookup_code, pov.one_time_flag, pov.hold_unmatched_invoices_flag,       PVS.VENDOR_SITE_CODE SUPPLIER_SITE, pvs.vendor_site_id,       pvs.last_update_date, (select description from apps.fnd_user where user_id = pvs.last_updated_by) update_who,       pvs.creation_date,   (select description from apps.fnd_user where user_id = pvs.created_by) create_who,       pvs.ship_to_location_id, pvs.bill_to_location_id,             pvs.accts_pay_code_combination_id, ...

Item Category Value select c.category_set_name, d.segment1 from  inv.mtl_item_categories b , inv.mtl_categories_b d , apps.MTL_CATEGORY_SETS_V c , apps.mtl_system_items_b msi where 1=1 and     B.CATEGORY_SET_ID = C.CATEGORY_SET_ID and         c.category_set_name = 'GE WHS LOCATION'  --'GE Product Hierarchy'         and B.CATEGORY_ID=D.CATEGORY_ID and         B.INVENTORY_ITEM_ID = msi.inventory_item_id         and b.organization_id = msi.organization_id         and msi.segment1 = '30308526'         and msi.organization_id = 804 ; Item Attachment SELECT fad.pk1_value, fad.pk2_value, msib.segment1, fdst.short_text attachment -- nvl(listagg(fdst.short_text, ' | ')  --within GROUP (ORDER BY fad.seq_num),' ') AS attachment FROM apps.fnd_attached_documents fad, apps.fnd_documents fd, apps.fnd_documents_short_text fdst...

Entity Structure: select LEV.LEDGER_ID LEDG_ID, LEV.LEDGER_NAME, LEV.CURRENCY_CODE CCY, LEV.LEGAL_ENTITY_ID LE_ID, LEV.LEGAL_ENTITY_NAME, LAD.ADDRESS_LINE_1, LAD.ADDRESS_LINE_2, LAD.ADDRESS_LINE_3, LAD.TOWN_OR_CITY, LAD.COUNTRY, OOD.OPERATING_UNIT OU_ID, OU.OPERATING_UNIT_NAME, OU.LOCATION_NAME, LEV.LOCATION_ID LOC_ID, LEV.LOCATION_CODE LOC_CODE, OOD.ORGANIZATION_ID ORG_ID, OOD.ORGANIZATION_CODE ORG_CODE, OOD.ORGANIZATION_NAME, houv.location_code, mp.attribute7 FROM       APPS.GL_LEDGER_LE_V LEV,       apps.org_organization_definitions OOD,       apps.HRFV_OPERATING_UNITS OU,       APPS.HR_LOCATION_LEGAL_ADR_V LAD,     apps.mtl_parameters mp ,APPS.GL_LEDGERS gl ,apps.HR_ORGANIZATION_UNITS_V houv WHERE         LEV.LEGAL_ENTITY_ID=OOD.LEGAL_ENTITY AND   OOD.OPERATING_UNIT=OU.OPERATING_UNITS_ID AND   OU.LOCATION_ID=LAD.LOCATION_ID(+) and ood.or...

Nainital Trip (29 Mar 2018 - 31 Mar 2018) Few factors coincided and I had a nice window for a small vacation. Jeshna's exams were over, next sessionw as still few days away. Archana had her school closed. I had some leaves about to lapse which I wanted to consume, and Shiva was always ready. To add to it, winters had just gone and it had not yet become real hot. So, all factors in favor, we can actually take a four day trip. Destination - Had many options in mind, but looking at distance, duration, my driving skills, weather - all these things, adding that Archana had never been to Nainital, this beautiful hill station was decided.  We were out to Nrahmputra Market for dinner on Wednesday. Came back by 11 PM in night. Then we discussed about a trip, agreed, started packing, finished packing by 2 AM, slept, and woke up at 5 AM for trip. The kids had slept already and when they woke up, they were already in car to Nainital. Most of journey was silent, as everyone was ...