APPS.INV_TRANSACTION_FLOW_PUB dependencies on RCV_TRANSACTIONS

Line 2953: rcv_transactions rt,

2949: INTO
2950: l_po_header_id, l_po_line_id, l_po_line_location_id,
2951: l_transaction_type, l_transaction_date, l_inventory_item_id,l_rcv_parent_txn_id
2952: FROM
2953: rcv_transactions rt,
2954: rcv_shipment_lines rsl
2955: WHERE
2956: transaction_id = p_rcv_transaction_id
2957: AND rt.shipment_line_id = rsl.shipment_line_id;

Line 2980: print_debug('Insufficient information in rcv_transactions', l_api_name);

2976:
2977: IF (l_po_header_id IS NULL) OR (l_po_line_id IS NULL) OR
2978: (l_po_line_location_id IS NULL) THEN
2979: IF l_debug = 1 then
2980: print_debug('Insufficient information in rcv_transactions', l_api_name);
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_NO_RCVTXN_INFO');
2983: fnd_msg_pub.add;
2984: RAISE fnd_api.g_exc_error;

Line 2997: from rcv_transactions

2993: as its original parent transaction*/
2994: begin
2995: select dropship_type_code
2996: into x_dropship_type_code
2997: from rcv_transactions
2998: where transaction_id = l_rcv_parent_txn_id;
2999: exception
3000: when NO_DATA_FOUND then
3001: x_dropship_type_code := G_PHYSICAL_RECEIPT_FOR_NON_DS;

Line 3273: , rcv_transactions RCT

3269: INTO l_organization_id, l_transaction_date
3270: FROM ic_whse_mst WHS
3271: , oe_order_lines_all OEL
3272: , oe_order_headers_all OEH
3273: , rcv_transactions RCT
3274: , po_requisition_headers_all poh
3275: , po_requisition_lines_all pol
3276: WHERE poh.requisition_header_id = pol.requisition_header_id
3277: AND pol.requisition_line_id = oel.orig_sys_document_Ref

Line 3331: FROM rcv_transactions rcv

3327: l_progress := 3;
3328: BEGIN
3329: select rcv.organization_id, transaction_date
3330: into l_organization_id, l_transaction_date
3331: FROM rcv_transactions rcv
3332: WHERE rcv.transaction_id = p_reference_id;
3333: EXCEPTION
3334: WHEN NO_DATA_FOUND then
3335: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

Line 4609: FROM rcv_transactions rcv

4605: print_debug('Inside p_global_procurement_flag = Y', 'GET_TRANSFER_PRICE');
4606: BEGIN
4607: select transaction_date
4608: into l_transaction_date
4609: FROM rcv_transactions rcv
4610: WHERE rcv.transaction_id = p_transaction_id;
4611: EXCEPTION
4612: WHEN NO_DATA_FOUND then
4613: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');

Line 5041: , rcv_transactions RCT

5037: select oel.pricing_date
5038: into l_trf_price_date
5039: from ic_whse_mst WHS
5040: , oe_order_lines_all OEL
5041: , rcv_transactions RCT
5042: , po_requisition_lines_all pol
5043: where pol.requisition_line_id = oel.orig_sys_document_Ref
5044: and oel.order_source_id = 10
5045: and RCT.transaction_id = l_line_id

Line 5095: FROM rcv_transactions rcv, po_headers_all poh

5091: print_debug('Inside p_global_procurement_flag =Y', 'GET_TRANSFER_PRICE_DATE');
5092: begin
5093: SELECT poh.approved_date
5094: into l_trf_price_date
5095: FROM rcv_transactions rcv, po_headers_all poh
5096: WHERE rcv.transaction_id = p_transaction_id
5097: AND rcv.po_header_id = poh.po_header_id;
5098: exception
5099: when no_data_found then