APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 677: FROM MSC_ITEM_ID_LID t1,

673: t1.INVENTORY_ITEM_ID,
674: msd.ORIGINATION_TYPE,
675: msd.SR_INSTANCE_ID,
676: msd.ORGANIZATION_ID
677: FROM MSC_ITEM_ID_LID t1,
678: MSC_ST_DEMANDS msd
679: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
680: AND msd.ORIGINATION_TYPE = 29
681: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

Line 722: MSC_ITEM_ID_LID t1,

718: msd.REVISED_DMD_DATE,
719: msd.REVISED_DMD_PRIORITY
720: FROM
721: -- msc_tp_id_lid c1,
722: MSC_ITEM_ID_LID t1,
723: MSC_ITEM_ID_LID t2,
724: MSC_DESIGNATORS md,
725: MSC_ST_DEMANDS msd
726: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id

Line 723: MSC_ITEM_ID_LID t2,

719: msd.REVISED_DMD_PRIORITY
720: FROM
721: -- msc_tp_id_lid c1,
722: MSC_ITEM_ID_LID t1,
723: MSC_ITEM_ID_LID t2,
724: MSC_DESIGNATORS md,
725: MSC_ST_DEMANDS msd
726: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
727: AND t1.sr_instance_id= msd.sr_instance_id

Line 831: ||' MSC_ITEM_ID_LID t1, '

827: ||' :v_current_user , '
828: ||' :v_current_date , '
829: ||' :v_current_user '
830: ||' FROM '
831: ||' MSC_ITEM_ID_LID t1, '
832: ||' MSC_ITEM_ID_LID t2, '
833: ||' MSC_DESIGNATORS md, '
834: ||' MSC_ST_DEMANDS msd '
835: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '

Line 832: ||' MSC_ITEM_ID_LID t2, '

828: ||' :v_current_date , '
829: ||' :v_current_user '
830: ||' FROM '
831: ||' MSC_ITEM_ID_LID t1, '
832: ||' MSC_ITEM_ID_LID t2, '
833: ||' MSC_DESIGNATORS md, '
834: ||' MSC_ST_DEMANDS msd '
835: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
836: ||' AND t1.sr_instance_id= msd.sr_instance_id '

Line 1663: MSC_ITEM_ID_LID t1,

1659: msd.SHIPPING_METHOD_CODE,
1660: mtsil.location_id ship_to_location_id
1661: FROM
1662: msc_tp_id_lid c1,
1663: MSC_ITEM_ID_LID t1,
1664: MSC_ITEM_ID_LID t2,
1665: MSC_DESIGNATORS md,
1666: MSC_TP_SITE_ID_LID mtsil,
1667: MSC_ST_DEMANDS msd

Line 1664: MSC_ITEM_ID_LID t2,

1660: mtsil.location_id ship_to_location_id
1661: FROM
1662: msc_tp_id_lid c1,
1663: MSC_ITEM_ID_LID t1,
1664: MSC_ITEM_ID_LID t2,
1665: MSC_DESIGNATORS md,
1666: MSC_TP_SITE_ID_LID mtsil,
1667: MSC_ST_DEMANDS msd
1668: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id

Line 2609: FROM MSC_ITEM_ID_LID t1,

2605: lv_sql1_2 :=
2606: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2607:
2608: lv_sql1_3:='
2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,
2611: MSC_ITEM_ID_LID t3,
2612: MSC_ST_SALES_ORDERS so,
2613: MSC_TP_ID_LID mtil,

Line 2610: MSC_ITEM_ID_LID t2,

2606: ' ,MSC_DEMANDS_S.nextval DEMAND_ID ';
2607:
2608: lv_sql1_3:='
2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,
2611: MSC_ITEM_ID_LID t3,
2612: MSC_ST_SALES_ORDERS so,
2613: MSC_TP_ID_LID mtil,
2614: MSC_TP_SITE_ID_LID mtsila,

Line 2611: MSC_ITEM_ID_LID t3,

2607:
2608: lv_sql1_3:='
2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,
2611: MSC_ITEM_ID_LID t3,
2612: MSC_ST_SALES_ORDERS so,
2613: MSC_TP_ID_LID mtil,
2614: MSC_TP_SITE_ID_LID mtsila,
2615: MSC_TP_SITE_ID_LID mtsilb

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

3080: mshr.SUPPLY_SOURCE_HEADER_ID,
3081: mshr.SUPPLY_SOURCE_TYPE_ID,
3082: mshr.REPAIR_PO_HEADER_ID, --SRP Changes For Bug 5996327
3083: mshr.DEMAND_SOURCE_LINE_ID
3084: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */
3085: MSC_ST_RESERVATIONS mshr
3086: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3087: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO
3088: AND t1.SR_INVENTORY_ITEM_ID= mshr.INVENTORY_ITEM_ID

Line 4226: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL

4222: :v_current_date,
4223: :v_current_user,
4224: :v_current_date,
4225: :v_current_user
4226: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL
4227: WHERE MIIL.SR_INVENTORY_ITEM_ID = MOP.inventory_item_id
4228: AND MIIL.sr_instance_id = MOP.sr_instance_id
4229: AND MOP.sr_instance_id = :v_instance_id';
4230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,lv_sql_ins);