DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on OE_DROP_SHIP_SOURCES

Line 22280: FROM oe_drop_ship_sources

22276: END IF;
22277:
22278: SELECT count(*)
22279: INTO l_count
22280: FROM oe_drop_ship_sources
22281: WHERE line_id = p_x_line_rec.line_id
22282: AND header_id = p_x_line_rec.header_id;
22283:
22284: IF l_count = 0 THEN

Line 22362: oe_drop_ship_sources odss,

22358: BEGIN
22359: SELECT Count(1)
22360: INTO l_rcv_count
22361: FROM rcv_transactions rcv,
22362: oe_drop_ship_sources odss,
22363: po_line_locations_all pol
22364: WHERE rcv.PO_LINE_ID=odss.po_line_id
22365: AND pol.line_location_id=odss.line_location_id
22366: AND odss.line_id=p_x_line_rec.line_id