APPS.INV_LABEL dependencies on RCV_TRANSACTIONS

Line 190: FROM RCV_TRANSACTIONS

186: trace('Business Flow in RECEIPT/INSPECTION/DELIVERY/PUTAWAY_DROP', TRACE_PROMPT,TRACE_LEVEL);
187:
188: SELECT ORGANIZATION_ID
189: INTO l_org_id
190: FROM RCV_TRANSACTIONS
191: WHERE GROUP_ID = p_transaction_id(1)
192: AND ROWNUM=1;
193:
194: ELSIF (p_business_flow = inv_label.WMS_BF_IMPORT_ASN) THEN

Line 200: FROM RCV_TRANSACTIONS

196: trace('Business Flow in IMPORT_ASN', TRACE_PROMPT,TRACE_LEVEL);
197:
198: SELECT ORGANIZATION_ID
199: INTO l_org_id
200: FROM RCV_TRANSACTIONS
201: WHERE SHIPMENT_HEADER_ID = p_transaction_id(1)
202: AND ROWNUM=1;
203:
204: ELSE

Line 210: trace('Value of org id from rcv_transactions ' || l_org_id, TRACE_PROMPT,TRACE_LEVEL);

206: trace('Some other business flow', TRACE_PROMPT,TRACE_LEVEL);
207:
208: END IF;
209:
210: trace('Value of org id from rcv_transactions ' || l_org_id, TRACE_PROMPT,TRACE_LEVEL);
211:
212: END IF;
213: -- End of fix for Bug 6888539
214: -- Start to check if this is a manual print request.

Line 2788: FROM rcv_transactions_interface rti

2784: trace(' b4 patchset J: interface_transaction_id: '||p_transaction_id(m), TRACE_PROMPT, TRACE_LEVEL);
2785: END IF;
2786: SELECT nvl(DECODE(p_business_flow_code,2,rti.transfer_lpn_id,rti.lpn_id),0)
2787: INTO l_lpn_table(m)
2788: FROM rcv_transactions_interface rti
2789: WHERE rti.interface_transaction_id = p_transaction_id(m);
2790: IF (l_debug = 1) THEN
2791: trace(' Got LPN_ID: '||l_lpn_table(m), TRACE_PROMPT, TRACE_LEVEL);
2792: trace(' for interface_transaction_id: '||p_transaction_id(m), TRACE_PROMPT, TRACE_LEVEL);