DBA Data[Home] [Help]

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on JAI_RCV_TRANSACTIONS

Line 3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308

3637: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is

Line 3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308

3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag

Line 3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308

3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag
3647: from jai_rcv_transactions jrcvt

Line 3647: from jai_rcv_transactions jrcvt

3643: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
3644: cp_attribute1 VARCHAR2) --Added by Bgowrava for Bug#7503308
3645: is
3646: select attribute2 excise_costing_flag
3647: from jai_rcv_transactions jrcvt
3648: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
3649: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
3650: and jrcvt.shipment_header_id = cp_shipment_header_id --Added by Bgowrava for Bug#7503308
3651: and jrcvt.transaction_type = cp_txn_type ;--'DELIVER' --Modified by Bgowrava for Bug#7503308