APPS.MRP_ATP_COLLECTION dependencies on MRP_ATP_SUPPLY_DEMAND

Line 14: DELETE FROM mrp_atp_supply_demand;

10: RETCODE := 0;
11: -- Before inserting new records, delete existing records
12: -- to prevent duplicates.
13:
14: DELETE FROM mrp_atp_supply_demand;
15:
16: -- SUPPLY DEMAND SOURCE TYPE (existing in mfg_lookups:)
17: -- 1: Purchase order
18: -- 2: Sales order

Line 56: INSERT INTO mrp_atp_supply_demand(

52:
53: -- Inserting new records.
54:
55: -- First insert onhand information.
56: INSERT INTO mrp_atp_supply_demand(
57: source_identifier1,
58: source_identifier2,
59: source_identifier3,
60: plan_id,

Line 133: INSERT INTO mrp_atp_supply_demand(

129: )
130: GROUP BY item_id, org_id;
131:
132: -- insert MPS supply
133: INSERT INTO mrp_atp_supply_demand(
134: source_identifier1,
135: source_identifier2,
136: source_identifier3,
137: plan_id,

Line 199: INSERT INTO mrp_atp_supply_demand(

195: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
196: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)));
197:
198: -- insert user defined supply
199: INSERT INTO mrp_atp_supply_demand(
200: source_identifier1,
201: source_identifier2,
202: source_identifier3,
203: plan_id,

Line 262: INSERT INTO mrp_atp_supply_demand(

258: -- However, in inldsd.ppc, it selects
259: -- S.TO_ORG_PRIMARY_QUANTITY for shipment, NVL(S.MRP_PRIMARY_QUANTITY, 0)
260: -- if discrete mps is included, S.TO_ORG_PRIMARY_QUANTITY if not included
261:
262: INSERT INTO mrp_atp_supply_demand(
263: source_identifier1,
264: source_identifier2,
265: source_identifier3,
266: plan_id,

Line 357: INSERT INTO mrp_atp_supply_demand(

353:
354: -- insert wip discrete job information
355: -- question here: do I need to apply bug 791215 here?
356: -- that is , using net_quantity instead of mps_net_quantity?
357: INSERT INTO mrp_atp_supply_demand(
358: source_identifier1,
359: source_identifier2,
360: source_identifier3,
361: plan_id,

Line 428: INSERT INTO mrp_atp_supply_demand(

424:
425: -- insert wip neg requirement information
426: -- I have applied bug 454103 here.
427:
428: INSERT INTO mrp_atp_supply_demand(
429: source_identifier1,
430: source_identifier2,
431: source_identifier3,
432: plan_id,

Line 496: INSERT INTO mrp_atp_supply_demand(

492:
493:
494: -- insert wip repetitive supply
495:
496: INSERT INTO mrp_atp_supply_demand(
497: source_identifier1,
498: source_identifier2,
499: source_identifier3,
500: plan_id,

Line 571: INSERT INTO mrp_atp_supply_demand(

567: -NVL(R.PAST_DUE_SUPPLY_CUTOFF_FENCE,0)));
568:
569: -- insert flow schedule supply information
570:
571: INSERT INTO mrp_atp_supply_demand(
572: source_identifier1,
573: source_identifier2,
574: source_identifier3,
575: plan_id,

Line 633: INSERT INTO mrp_atp_supply_demand(

629:
630: -- now we insert the demand information
631: -- insert wip discrete requirement information
632:
633: INSERT INTO mrp_atp_supply_demand(
634: source_identifier1,
635: source_identifier2,
636: source_identifier3,
637: plan_id,

Line 703: INSERT INTO mrp_atp_supply_demand(

699:
700: -- insert wip repetitive requirement information
701: -- unlike inldsd.ppc, I combine DRJ1 and DRJ2
702:
703: INSERT INTO mrp_atp_supply_demand(
704: source_identifier1,
705: source_identifier2,
706: source_identifier3,
707: plan_id,

Line 783: INSERT INTO mrp_atp_supply_demand(

779: MRP_CALENDAR.DATE_OFFSET(P.ORGANIZATION_ID, 1, SYSDATE,
780: -NVL(R.PAST_DUE_DEMAND_CUTOFF_FENCE,0)));
781:
782: -- insert user defined demand information
783: INSERT INTO mrp_atp_supply_demand(
784: source_identifier1,
785: source_identifier2,
786: source_identifier3,
787: plan_id,

Line 840: INSERT INTO mrp_atp_supply_demand(

836:
837: -- insert wip flow schedule demand information
838: -- haven't added the logic to explode phantom
839:
840: INSERT INTO mrp_atp_supply_demand(
841: source_identifier1,
842: source_identifier2,
843: source_identifier3,
844: plan_id,

Line 911: INSERT INTO mrp_atp_supply_demand(

907:
908: IF l_oe_install = 'OE' THEN
909:
910: -- insert sales order demand
911: INSERT INTO mrp_atp_supply_demand(
912: source_identifier1,
913: source_identifier2,
914: source_identifier3,
915: source_identifier4,

Line 989: INSERT INTO mrp_atp_supply_demand(

985: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
986: AND C.CALENDAR_DATE = TRUNC(D.REQUIREMENT_DATE);
987:
988: ELSE
989: INSERT INTO mrp_atp_supply_demand(
990: source_identifier1,
991: source_identifier2,
992: source_identifier3,
993: plan_id,

Line 1053: INSERT INTO mrp_atp_supply_demand(

1049:
1050: l_instance_id := ****
1051:
1052: -- select demand records from ODS for items
1053: INSERT INTO mrp_atp_supply_demand(
1054: source_identifier1,
1055: source_identifier2,
1056: source_identifier3,
1057: plan_id,