APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 629: FROM MSC_ITEM_ID_LID t1,

625: t1.INVENTORY_ITEM_ID,
626: msd.ORIGINATION_TYPE,
627: msd.SR_INSTANCE_ID,
628: msd.ORGANIZATION_ID
629: FROM MSC_ITEM_ID_LID t1,
630: MSC_ST_DEMANDS msd
631: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
632: AND msd.ORIGINATION_TYPE = 29
633: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

Line 672: MSC_ITEM_ID_LID t1,

668: md.ship_id CUSTOMER_SITE_ID,
669: md.ship_id SHIP_TO_SITE_ID
670: FROM
671: -- msc_tp_id_lid c1,
672: MSC_ITEM_ID_LID t1,
673: MSC_ITEM_ID_LID t2,
674: MSC_DESIGNATORS md,
675: MSC_ST_DEMANDS msd
676: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id

Line 673: MSC_ITEM_ID_LID t2,

669: md.ship_id SHIP_TO_SITE_ID
670: FROM
671: -- msc_tp_id_lid c1,
672: MSC_ITEM_ID_LID t1,
673: MSC_ITEM_ID_LID t2,
674: MSC_DESIGNATORS md,
675: MSC_ST_DEMANDS msd
676: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
677: AND t1.sr_instance_id= msd.sr_instance_id

Line 777: ||' MSC_ITEM_ID_LID t1, '

773: ||' :v_current_user , '
774: ||' :v_current_date , '
775: ||' :v_current_user '
776: ||' FROM '
777: ||' MSC_ITEM_ID_LID t1, '
778: ||' MSC_ITEM_ID_LID t2, '
779: ||' MSC_DESIGNATORS md, '
780: ||' MSC_ST_DEMANDS msd '
781: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '

Line 778: ||' MSC_ITEM_ID_LID t2, '

774: ||' :v_current_date , '
775: ||' :v_current_user '
776: ||' FROM '
777: ||' MSC_ITEM_ID_LID t1, '
778: ||' MSC_ITEM_ID_LID t2, '
779: ||' MSC_DESIGNATORS md, '
780: ||' MSC_ST_DEMANDS msd '
781: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
782: ||' AND t1.sr_instance_id= msd.sr_instance_id '

Line 1394: MSC_ITEM_ID_LID t1,

1390: msd.SHIPPING_METHOD_CODE,
1391: mtsil.location_id ship_to_location_id
1392: FROM
1393: msc_tp_id_lid c1,
1394: MSC_ITEM_ID_LID t1,
1395: MSC_ITEM_ID_LID t2,
1396: MSC_DESIGNATORS md,
1397: MSC_TP_SITE_ID_LID mtsil,
1398: MSC_ST_DEMANDS msd

Line 1395: MSC_ITEM_ID_LID t2,

1391: mtsil.location_id ship_to_location_id
1392: FROM
1393: msc_tp_id_lid c1,
1394: MSC_ITEM_ID_LID t1,
1395: MSC_ITEM_ID_LID t2,
1396: MSC_DESIGNATORS md,
1397: MSC_TP_SITE_ID_LID mtsil,
1398: MSC_ST_DEMANDS msd
1399: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id

Line 2300: FROM MSC_ITEM_ID_LID t1,

2296: lv_sql1_2 :=
2297: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2298:
2299: lv_sql1_3:='
2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,
2302: MSC_ITEM_ID_LID t3,
2303: MSC_ST_SALES_ORDERS so,
2304: MSC_TP_ID_LID mtil,

Line 2301: MSC_ITEM_ID_LID t2,

2297: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2298:
2299: lv_sql1_3:='
2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,
2302: MSC_ITEM_ID_LID t3,
2303: MSC_ST_SALES_ORDERS so,
2304: MSC_TP_ID_LID mtil,
2305: MSC_TP_SITE_ID_LID mtsila,

Line 2302: MSC_ITEM_ID_LID t3,

2298:
2299: lv_sql1_3:='
2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,
2302: MSC_ITEM_ID_LID t3,
2303: MSC_ST_SALES_ORDERS so,
2304: MSC_TP_ID_LID mtil,
2305: MSC_TP_SITE_ID_LID mtsila,
2306: MSC_TP_SITE_ID_LID mtsilb

Line 2751: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */

2747: mshr.SR_INSTANCE_ID,
2748: mshr.SUPPLY_SOURCE_HEADER_ID,
2749: mshr.SUPPLY_SOURCE_TYPE_ID,
2750: mshr.REPAIR_PO_HEADER_ID --SRP Changes For Bug 5996327
2751: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */
2752: MSC_ST_RESERVATIONS mshr
2753: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2754: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO
2755: AND t1.SR_INVENTORY_ITEM_ID= mshr.INVENTORY_ITEM_ID

Line 3491: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL

3487: :v_current_date,
3488: :v_current_user,
3489: :v_current_date,
3490: :v_current_user
3491: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL
3492: WHERE MIIL.SR_INVENTORY_ITEM_ID = MOP.inventory_item_id
3493: AND MIIL.sr_instance_id = MOP.sr_instance_id
3494: AND MOP.sr_instance_id = :v_instance_id';
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,lv_sql_ins);