DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 270: OE_DROP_SHIP_SOURCES OEDSS

266: --
267: CURSOR drop_ship_line_cost IS
268: SELECT POL.UNIT_PRICE
269: FROM PO_LINES_ALL POL,
270: OE_DROP_SHIP_SOURCES OEDSS
271: WHERE OEDSS.LINE_ID = l_line_rec.line_id
272: AND OEDSS.PO_RELEASE_ID IS NULL
273: AND POL.PO_LINE_ID = OEDSS.PO_LINE_ID
274: UNION

Line 277: OE_DROP_SHIP_SOURCES OEDSS

273: AND POL.PO_LINE_ID = OEDSS.PO_LINE_ID
274: UNION
275: SELECT PRL.UNIT_PRICE
276: FROM PO_REQUISITION_LINES_ALL PRL,
277: OE_DROP_SHIP_SOURCES OEDSS
278: WHERE OEDSS.LINE_ID = l_line_rec.line_id
279: AND OEDSS.PO_LINE_ID IS NULL
280: AND PRL.REQUISITION_LINE_ID = OEDSS.REQUISITION_LINE_ID
281: UNION

Line 284: OE_DROP_SHIP_SOURCES OEDSS

280: AND PRL.REQUISITION_LINE_ID = OEDSS.REQUISITION_LINE_ID
281: UNION
282: SELECT POLL.PRICE_OVERRIDE UNIT_PRICE
283: FROM PO_LINE_LOCATIONS_ALL POLL,
284: OE_DROP_SHIP_SOURCES OEDSS
285: WHERE OEDSS.LINE_ID = l_line_rec.line_id
286: AND OEDSS.PO_LINE_ID IS NOT NULL
287: AND POLL.LINE_LOCATION_ID = OEDSS.LINE_LOCATION_ID
288: AND OEDSS.PO_RELEASE_ID IS NOT NULL;