DBA Data[Home] [Help]

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on RCV_TRANSACTIONS

Line 72: FROM JAI_RCV_TRANSACTIONS

68: );
69:
70: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
71: SELECT *
72: FROM JAI_RCV_TRANSACTIONS
73: WHERE transaction_id = cp_transaction_id;
74:
75: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
76: SELECT shipment_header_id, requisition_line_id, primary_quantity, uom_code, unit_of_measure,

Line 81: FROM rcv_transactions

77: po_header_id, po_line_id, po_line_location_id, transaction_id, subinventory,
78: vendor_id, vendor_site_id, customer_id, customer_site_id, oe_order_line_id,
79: transaction_type, destination_type_code, source_document_code, quantity
80: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ,attribute_category attr_cat, attribute1, attribute2, attribute3, attribute4, attribute5 rma_type
81: FROM rcv_transactions
82: WHERE transaction_id = cp_transaction_id;
83:
84: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
85: CURSOR c_jai_receipt_line(cp_shipment_line_id IN NUMBER) IS