DBA Data[Home] [Help]

APPS.QA_SAMPLING_PKG dependencies on RCV_SERIALS_SUPPLY

Line 106: from rcv_lots_supply rls, rcv_serials_supply rss

102: l_quantity NUMBER;
103:
104: CURSOR lot_ser_supply IS
105: select rls.lot_num, rss.serial_num, decode(rss.serial_num, NULL, rls.quantity, 1)
106: from rcv_lots_supply rls, rcv_serials_supply rss
107: where rls.transaction_id = rss.transaction_id (+)
108: and rls.transaction_id = p_transaction_id
109: and rls.lot_num = rss.lot_num (+)
110: UNION

Line 112: from rcv_lots_supply rls, rcv_serials_supply rss

108: and rls.transaction_id = p_transaction_id
109: and rls.lot_num = rss.lot_num (+)
110: UNION
111: select rls.lot_num, rss.serial_num, decode(rss.serial_num, NULL, rls.quantity, 1)
112: from rcv_lots_supply rls, rcv_serials_supply rss
113: where rls.transaction_id (+) = rss.transaction_id
114: and rss.transaction_id = p_transaction_id
115: and rls.lot_num (+) = rss.lot_num;
116: