eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on JMF_SHIKYU_REPLENISHMENTS

Line 50: --| columns of the JMF_SHIKYU_REPLENISHMENTS|

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 |

Line 1836: FROM jmf_shikyu_replenishments jsr

1832: AND
1833: (NVL(p_to_organization, hoi.organization_id)
1834: )
1835: AND NOT EXISTS (SELECT jsr.replenishment_so_line_id
1836: FROM jmf_shikyu_replenishments jsr
1837: WHERE jsr.replenishment_po_shipment_id = plla.line_location_id)
1838: ORDER BY plla.need_by_date,
1839: pha.segment1,
1840: pla.line_num,

Line 2189: INSERT INTO JMF_SHIKYU_REPLENISHMENTS

2185: || ', l_tp_supplier_site_id = ' || l_tp_supplier_site_id
2186: );
2187: END IF;
2188:
2189: INSERT INTO JMF_SHIKYU_REPLENISHMENTS
2190: ( replenishment_so_line_id
2191: , replenishment_so_header_id
2192: , schedule_ship_date
2193: , replenishment_po_header_id