APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2683: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE

2679: , component_id NUMBER
2680: , qty NUMBER
2681: , qty_uom VARCHAR2(3)
2682: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2683: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2684: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2685: );
2686:
2687: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;

Line 2715: OE_ORDER_HEADERS_ALL ooha

2711: , ooha.order_number
2712: , oola.line_number
2713: FROM JMF_SHIKYU_ALLOCATIONS jsa,
2714: OE_ORDER_LINES_ALL oola,
2715: OE_ORDER_HEADERS_ALL ooha
2716: WHERE jsa.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2717: AND jsa.shikyu_component_id = p_component_id
2718: AND oola.line_id = jsa.replenishment_so_line_id
2719: AND ooha.header_id = oola.header_id

Line 3736: , OE_ORDER_HEADERS_ALL oeh

3732: , jsr.allocable_quantity allocable_quantity
3733: , jsr.allocated_quantity allocated_quantity
3734: FROM JMF_SHIKYU_REPLENISHMENTS jsr
3735: , OE_ORDER_LINES_ALL oel
3736: , OE_ORDER_HEADERS_ALL oeh
3737: , JMF_SHIKYU_ALLOCATIONS jsa
3738: WHERE oeh.header_id = jsr.REPLENISHMENT_SO_HEADER_ID
3739: AND oel.header_id = oeh.header_id
3740: AND oel.line_id = jsr.replenishment_so_line_id

Line 4848: oe_order_headers_all ooha

4844: WHERE jsc.shikyu_component_id = p_component_id
4845: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4846: AND EXISTS (SELECT 'x'
4847: FROM oe_order_lines_all oola,
4848: oe_order_headers_all ooha
4849: WHERE oola.line_id = p_replen_so_line_id
4850: AND oola.inventory_item_id = p_component_id
4851: AND oola.price_list_id = jsc.price_list_id
4852: AND oola.header_id = ooha.header_id