[Home] [Help]
46: --| replenishment so lines were created for |
47: --| each replensihment po shipment. |
48: --| 10/26/2005 vchu Modified the value to populate into the |
49: --| TP_SUPPLIER_ID and TP_SUPPLIER_SITE_ID |
50: --| columns of the JMF_SHIKYU_REPLENISHMENTS|
51: --| table for fixing the wrong value issue |
52: --| of the Manufacturing Partner / MP site |
53: --| as described in bug 4651480. |
54: --| Also fixed the logic of the LOOP in the |
1661: AND
1662: (NVL(p_to_organization, hoi.organization_id)
1663: )
1664: AND NOT EXISTS (SELECT jsr.replenishment_so_line_id
1665: FROM jmf_shikyu_replenishments jsr
1666: WHERE jsr.replenishment_po_shipment_id = plla.line_location_id)
1667: ORDER BY plla.need_by_date,
1668: pha.segment1,
1669: pla.line_num,
1971: FROM hr_organization_information
1972: WHERE organization_id = l_tp_organization_id
1973: AND org_information_context = 'Customer/Supplier Association';
1974:
1975: INSERT INTO JMF_SHIKYU_REPLENISHMENTS
1976: ( replenishment_so_line_id
1977: , replenishment_so_header_id
1978: , schedule_ship_date
1979: , replenishment_po_header_id