DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 343: OE_DROP_SHIP_SOURCES OEDSS

339: --
340: CURSOR drop_ship_line_cost IS
341: SELECT POL.UNIT_PRICE
342: FROM PO_LINES_ALL POL,
343: OE_DROP_SHIP_SOURCES OEDSS
344: WHERE OEDSS.LINE_ID = l_line_rec.line_id
345: AND OEDSS.PO_RELEASE_ID IS NULL
346: AND POL.PO_LINE_ID = OEDSS.PO_LINE_ID
347: UNION

Line 350: OE_DROP_SHIP_SOURCES OEDSS

346: AND POL.PO_LINE_ID = OEDSS.PO_LINE_ID
347: UNION
348: SELECT PRL.UNIT_PRICE
349: FROM PO_REQUISITION_LINES_ALL PRL,
350: OE_DROP_SHIP_SOURCES OEDSS
351: WHERE OEDSS.LINE_ID = l_line_rec.line_id
352: AND OEDSS.PO_LINE_ID IS NULL
353: AND PRL.REQUISITION_LINE_ID = OEDSS.REQUISITION_LINE_ID
354: UNION

Line 357: OE_DROP_SHIP_SOURCES OEDSS

353: AND PRL.REQUISITION_LINE_ID = OEDSS.REQUISITION_LINE_ID
354: UNION
355: SELECT POLL.PRICE_OVERRIDE UNIT_PRICE
356: FROM PO_LINE_LOCATIONS_ALL POLL,
357: OE_DROP_SHIP_SOURCES OEDSS
358: WHERE OEDSS.LINE_ID = l_line_rec.line_id
359: AND OEDSS.PO_LINE_ID IS NOT NULL
360: AND POLL.LINE_LOCATION_ID = OEDSS.LINE_LOCATION_ID
361: AND OEDSS.PO_RELEASE_ID IS NOT NULL;