DBA Data[Home] [Help]

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on RCV_TRANSACTIONS

Line 87: FROM JAI_RCV_TRANSACTIONS

83: );
84:
85: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
86: SELECT *
87: FROM JAI_RCV_TRANSACTIONS
88: WHERE transaction_id = cp_transaction_id;
89:
90: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
91: SELECT shipment_header_id, requisition_line_id, primary_quantity, uom_code, unit_of_measure,

Line 96: FROM rcv_transactions

92: po_header_id, po_line_id, po_line_location_id, transaction_id, subinventory,
93: vendor_id, vendor_site_id, customer_id, customer_site_id, oe_order_line_id,
94: transaction_type, destination_type_code, source_document_code, quantity
95: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ,attribute_category attr_cat, attribute1, attribute2, attribute3, attribute4, attribute5 rma_type
96: FROM rcv_transactions
97: WHERE transaction_id = cp_transaction_id;
98:
99: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
100: CURSOR c_jai_receipt_line(cp_shipment_line_id IN NUMBER) IS