APPS.MSC_ATP_UTILS dependencies on MTL_DEMAND_INTERFACE

Line 877: FROM mtl_demand_interface mdi3,

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

Line 878: mtl_demand_interface mdi

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

Line 979: MTL_DEMAND_INTERFACE mdi

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

Line 983: FROM mtl_demand_interface

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

Line 987: FROM mtl_demand_interface

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

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

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

Line 1037: UPDATE mtl_demand_interface set

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

Line 1072: UPDATE mtl_demand_interface

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