APPS.WPS_SUPPLY_DEMAND dependencies on MTL_SUPPLY

Line 245: Collect_MTL_Supply(p_group_id => p_group_id,

241: p_supply_table => p_supply_table,
242: ERRBUF => ERRBUF,
243: RETCODE => RETCODE);
244:
245: Collect_MTL_Supply(p_group_id => p_group_id,
246: p_sys_seq_num => p_sys_seq_num,
247: p_mrp_status => p_mrp_status,
248: p_supply_table => p_supply_table,
249: ERRBUF => ERRBUF,

Line 538: PROCEDURE Collect_MTL_Supply(p_group_id IN NUMBER,

534:
535: END Collect_User_Supply;
536:
537:
538: PROCEDURE Collect_MTL_Supply(p_group_id IN NUMBER,
539: p_sys_seq_num IN NUMBER,
540: p_mrp_status IN NUMBER,
541: p_supply_table IN OUT NOCOPY SUPPLY_DEMAND_TBL_TYPE,
542: ERRBUF OUT NOCOPY VARCHAR2,

Line 546: -- queries mtl_supply information, that is PO, REQ, SHIP, RCV

542: ERRBUF OUT NOCOPY VARCHAR2,
543: RETCODE OUT NOCOPY NUMBER)
544: IS
545:
546: -- queries mtl_supply information, that is PO, REQ, SHIP, RCV
547: -- question here,
548: -- I select NVL(S.MRP_PRIMARY_QUANTITY, S.TO_ORG_PRIMARY_QUANTITY)
549: -- as the supply_demand_quantity if discrete mps is included,
550: -- S.TO_ORG_PRIMARY_QUANTITY if not included.

Line 555: CURSOR MTL_SUPPLY_CURSOR IS

551: -- However, in inldsd.ppc, it selects
552: -- S.TO_ORG_PRIMARY_QUANTITY for shipment, NVL(S.MRP_PRIMARY_QUANTITY, 0)
553: -- if discrete mps is included, S.TO_ORG_PRIMARY_QUANTITY if not included
554:
555: CURSOR MTL_SUPPLY_CURSOR IS
556: SELECT
557: 1 reservation_type,
558: DECODE(S.PO_HEADER_ID,
559: NULL,DECODE(S.SUPPLY_TYPE_CODE,

Line 592: MTL_SUPPLY S

588: MTL_ATP_RULES R,
589: MTL_SYSTEM_ITEMS I,
590: MTL_PARAMETERS P,
591: BOM_CALENDAR_DATES C,
592: MTL_SUPPLY S
593: WHERE V.ATP_GROUP_ID = P_GROUP_ID
594: AND R.DEMAND_CLASS_ATP_FLAG=2
595: AND V.AVAILABLE_TO_ATP = 1
596: AND V.ATP_RULE_ID = R.RULE_ID

Line 634: l_supply_rec MTL_SUPPLY_CURSOR%ROWTYPE;

630: AND P.CALENDAR_CODE = C.CALENDAR_CODE
631: AND P.CALENDAR_EXCEPTION_SET_ID = C.EXCEPTION_SET_ID
632: AND C.CALENDAR_DATE = TRUNC(S.EXPECTED_DELIVERY_DATE);
633:
634: l_supply_rec MTL_SUPPLY_CURSOR%ROWTYPE;
635: j NUMBER := Nvl(p_supply_table.LAST,0) + 1;
636: BEGIN
637:
638: OPEN MTL_SUPPLY_CURSOR;

Line 638: OPEN MTL_SUPPLY_CURSOR;

634: l_supply_rec MTL_SUPPLY_CURSOR%ROWTYPE;
635: j NUMBER := Nvl(p_supply_table.LAST,0) + 1;
636: BEGIN
637:
638: OPEN MTL_SUPPLY_CURSOR;
639:
640: LOOP
641: FETCH MTL_SUPPLY_CURSOR INTO l_supply_rec;
642: EXIT WHEN MTL_SUPPLY_CURSOR%NOTFOUND;

Line 641: FETCH MTL_SUPPLY_CURSOR INTO l_supply_rec;

637:
638: OPEN MTL_SUPPLY_CURSOR;
639:
640: LOOP
641: FETCH MTL_SUPPLY_CURSOR INTO l_supply_rec;
642: EXIT WHEN MTL_SUPPLY_CURSOR%NOTFOUND;
643:
644: p_supply_table(j).reservation_type := l_supply_rec.reservation_type;
645: p_supply_table(j).supply_demand_source_type := l_supply_rec.supply_demand_source_type;

Line 642: EXIT WHEN MTL_SUPPLY_CURSOR%NOTFOUND;

638: OPEN MTL_SUPPLY_CURSOR;
639:
640: LOOP
641: FETCH MTL_SUPPLY_CURSOR INTO l_supply_rec;
642: EXIT WHEN MTL_SUPPLY_CURSOR%NOTFOUND;
643:
644: p_supply_table(j).reservation_type := l_supply_rec.reservation_type;
645: p_supply_table(j).supply_demand_source_type := l_supply_rec.supply_demand_source_type;
646: p_supply_table(j).txn_source_type_id := l_supply_rec.txn_source_type_id;

Line 658: CLOSE MTL_SUPPLY_CURSOR;

654: j := j+1;
655:
656: END LOOP;
657:
658: CLOSE MTL_SUPPLY_CURSOR;
659:
660: END Collect_MTL_Supply;
661:
662: PROCEDURE Collect_DiscreteJob_Supply(p_group_id IN NUMBER,

Line 660: END Collect_MTL_Supply;

656: END LOOP;
657:
658: CLOSE MTL_SUPPLY_CURSOR;
659:
660: END Collect_MTL_Supply;
661:
662: PROCEDURE Collect_DiscreteJob_Supply(p_group_id IN NUMBER,
663: p_sys_seq_num IN NUMBER,
664: p_mrp_status IN NUMBER,