APPS.MSC_ATP_UTILS dependencies on MTL_DEMAND_INTERFACE

Line 879: FROM mtl_demand_interface mdi3,

875: BEGIN
876:
877: SELECT NVL(count(*),0)
878: INTO v_dummy
879: FROM mtl_demand_interface mdi3,
880: mtl_demand_interface mdi
881: WHERE mdi3.demand_source_header_id = mdi.demand_source_header_id
882: AND mdi3.demand_source_line = mdi.demand_source_line
883: AND mdi3.demand_source_delivery = mdi.demand_source_delivery

Line 880: mtl_demand_interface mdi

876:
877: SELECT NVL(count(*),0)
878: INTO v_dummy
879: FROM mtl_demand_interface mdi3,
880: mtl_demand_interface mdi
881: WHERE mdi3.demand_source_header_id = mdi.demand_source_header_id
882: AND mdi3.demand_source_line = mdi.demand_source_line
883: AND mdi3.demand_source_delivery = mdi.demand_source_delivery
884: AND mdi3.demand_source_type = mdi.demand_source_type

Line 981: MTL_DEMAND_INTERFACE mdi

977: FROM
978: mrp_ap_apps_instances mai,
979: ORG_ORGANIZATION_DEFINITIONS ood,
980: MTL_SYSTEM_ITEMS msi,
981: MTL_DEMAND_INTERFACE mdi
982: WHERE mdi.atp_group_id = p_group_id
983: AND ((mdi.demand_type = 1
984: AND EXISTS (SELECT 'ATO Model exists'
985: FROM mtl_demand_interface

Line 985: FROM mtl_demand_interface

981: MTL_DEMAND_INTERFACE mdi
982: WHERE mdi.atp_group_id = p_group_id
983: AND ((mdi.demand_type = 1
984: AND EXISTS (SELECT 'ATO Model exists'
985: FROM mtl_demand_interface
986: WHERE atp_group_id = mdi.atp_group_id
987: AND demand_type = 1))
988: OR NOT EXISTS (SELECT 'ATO Model exists'
989: FROM mtl_demand_interface

Line 989: FROM mtl_demand_interface

985: FROM mtl_demand_interface
986: WHERE atp_group_id = mdi.atp_group_id
987: AND demand_type = 1))
988: OR NOT EXISTS (SELECT 'ATO Model exists'
989: FROM mtl_demand_interface
990: WHERE atp_group_id = mdi.atp_group_id
991: AND demand_type = 1))
992: AND Nvl(mdi.process_flag,1) = 1
993: AND nvl(mdi.error_code,61) = 61

Line 998: -- Update mtl_demand_interface with the right return values

994: AND ood.organization_id = mdi.organization_id
995: AND msi.organization_id = mdi.organization_id
996: AND msi.inventory_item_id = mdi.inventory_item_id;
997:
998: -- Update mtl_demand_interface with the right return values
999: -- call atp module
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));

Line 1039: UPDATE mtl_demand_interface set

1035:
1036:
1037: IF x_return_status <> FND_API.g_ret_sts_success THEN
1038: FOR j IN 1..x_atp_rec_out.Inventory_Item_Id.COUNT loop
1039: UPDATE mtl_demand_interface set
1040: LAST_UPDATE_DATE = SYSDATE,
1041: Error_Code = X_atp_rec_out.error_code(j),
1042: Err_Explanation = X_atp_rec_out.message(j)
1043: WHERE rowid = Chartorowid(X_atp_rec_out.row_id(j));

Line 1074: UPDATE mtl_demand_interface

1070: -- ?? Infinite_time_fence_date is being updated in inlatp.ppc
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'christine, request date atp q is'||x_Atp_rec_out.requested_date_quantity(j));
1073: END IF;
1074: UPDATE mtl_demand_interface
1075: SET Request_Date_ATP_Quantity = x_Atp_rec_out.requested_date_quantity(j),
1076: Request_ATP_Date = To_date(To_char(X_atp_rec_out.ship_date(j), 'J'),'J'),
1077: Request_ATP_Date_Quantity = X_atp_rec_out.available_quantity(j),
1078: Group_Available_Date = NVL(X_atp_rec_out.group_ship_date(j),