DBA Data[Home] [Help]

APPS.POS_COMPLEX_WORK_PVT dependencies on RCV_SHIPMENT_LINES

Line 96: from RCV_SHIPMENT_LINES RSL,

92:
93:
94: CURSOR l_amt_delivered_csr IS
95: select sum(NVL(RSL.amount, NVL(RSL.quantity_shipped,0)*NVL(PLL.price_override,0)))
96: from RCV_SHIPMENT_LINES RSL,
97: PO_LINE_LOCATIONS_ALL PLL
98: where PLL.po_header_id = p_po_header_id
99: and PLL.shipment_type = 'STANDARD'
100: and PLL.payment_type = 'DELIVERY'

Line 229: from RCV_SHIPMENT_LINES RSL,

225: NVL(RSL.amount,RSL.REQUESTED_AMOUNT), --5488052
226: NVL(RSL.quantity_shipped,0)*NVL(PLL.price_override,0)
227: )
228: )
229: from RCV_SHIPMENT_LINES RSL,
230: PO_LINE_LOCATIONS_ALL PLL
231: where PLL.po_line_id = p_po_line_id
232: and PLL.shipment_type = 'STANDARD'
233: --5488052 and PLL.payment_type = 'DELIVERY'