APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2691: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE

2687: , qty_uom VARCHAR2(3)
2688: --Bugfix 14246759: Adding actual_shipment_date
2689: , rso_line_actual_ship_date OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE%TYPE
2690: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2691: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2692: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2693: );
2694:
2695: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;

Line 2725: OE_ORDER_HEADERS_ALL ooha

2721: , ooha.order_number
2722: , oola.line_number
2723: FROM JMF_SHIKYU_ALLOCATIONS jsa,
2724: OE_ORDER_LINES_ALL oola,
2725: OE_ORDER_HEADERS_ALL ooha
2726: WHERE jsa.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2727: AND jsa.shikyu_component_id = p_component_id
2728: AND oola.line_id = jsa.replenishment_so_line_id
2729: AND ooha.header_id = oola.header_id

Line 4062: , OE_ORDER_HEADERS_ALL oeh

4058: , jsr.allocable_quantity allocable_quantity
4059: , jsr.allocated_quantity allocated_quantity
4060: FROM JMF_SHIKYU_REPLENISHMENTS jsr
4061: , OE_ORDER_LINES_ALL oel
4062: , OE_ORDER_HEADERS_ALL oeh
4063: , JMF_SHIKYU_ALLOCATIONS jsa
4064: WHERE oeh.header_id = jsr.REPLENISHMENT_SO_HEADER_ID
4065: AND oel.header_id = oeh.header_id
4066: AND oel.line_id = jsr.replenishment_so_line_id

Line 5292: oe_order_headers_all ooha

5288: WHERE jsc.shikyu_component_id = p_component_id
5289: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5290: AND EXISTS (SELECT 'x'
5291: FROM oe_order_lines_all oola,
5292: oe_order_headers_all ooha
5293: WHERE oola.line_id = p_replen_so_line_id
5294: AND oola.inventory_item_id = p_component_id
5295: AND oola.price_list_id = jsc.price_list_id
5296: AND oola.header_id = ooha.header_id