DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on JMF_SHIKYU_ALLOCATIONS

Line 830: FROM JMF_SHIKYU_ALLOCATIONS

826: THEN
827: BEGIN
828: SELECT SUBCONTRACT_PO_SHIPMENT_ID
829: INTO L_SUBCONTRACT_PO_SHIPMENT_ID
830: FROM JMF_SHIKYU_ALLOCATIONS
831: WHERE SUBCONTRACT_PO_SHIPMENT_ID <>
832: p_subcontract_po_shipment_id
833: AND REPLENISHMENT_SO_LINE_ID = p_replen_so_line_id ;
834:

Line 920: FROM JMF_SHIKYU_ALLOCATIONS alc

916: , oel.CANCELLED_FLAG
917: , oel.OPEN_FLAG
918: , oel.BOOKED_FLAG
919: , oel.shipping_interfaced_flag
920: FROM JMF_SHIKYU_ALLOCATIONS alc
921: , OE_ORDER_LINES_ALL oel
922: WHERE alc.SUBCONTRACT_PO_SHIPMENT_ID = p_SUBCONTRACT_PO_SHIPMENT_ID
923: AND oel.line_id = alc.REPLENISHMENT_SO_LINE_ID
924: AND oel.open_flag = 'Y'