DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on RCV_TRANSACTIONS

Line 121: G_RCV_TRANSACTIONS_MARKED_O NUMBER;

117: G_DISC_INTERFACE_ID NUMBER;
118: G_Profile_Discount_Start_date DATE;
119:
120: -- Receipt Accruals
121: G_RCV_TRANSACTIONS_MARKED_O NUMBER;
122: G_RCV_TRANSACTIONS_MARKED_J NUMBER;
123: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;
124: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
125: G_NUM_RCV_TXN_PROCESSED NUMBER;

Line 122: G_RCV_TRANSACTIONS_MARKED_J NUMBER;

118: G_Profile_Discount_Start_date DATE;
119:
120: -- Receipt Accruals
121: G_RCV_TRANSACTIONS_MARKED_O NUMBER;
122: G_RCV_TRANSACTIONS_MARKED_J NUMBER;
123: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;
124: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
125: G_NUM_RCV_TXN_PROCESSED NUMBER;
126: G_NUM_RCVTAX_PROCESSED NUMBER;

Line 123: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;

119:
120: -- Receipt Accruals
121: G_RCV_TRANSACTIONS_MARKED_O NUMBER;
122: G_RCV_TRANSACTIONS_MARKED_J NUMBER;
123: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;
124: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
125: G_NUM_RCV_TXN_PROCESSED NUMBER;
126: G_NUM_RCVTAX_PROCESSED NUMBER;
127: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

Line 124: G_RCV_TRANSACTIONS_MARKED_G NUMBER;

120: -- Receipt Accruals
121: G_RCV_TRANSACTIONS_MARKED_O NUMBER;
122: G_RCV_TRANSACTIONS_MARKED_J NUMBER;
123: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;
124: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
125: G_NUM_RCV_TXN_PROCESSED NUMBER;
126: G_NUM_RCVTAX_PROCESSED NUMBER;
127: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
128: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

Line 616: /*bug13922293 pulling it from rcv_transactions */

612: rcv_sub.code_combination_id dr_cc_id,
613: rcv_sub.CURRENCY_CODE denom_currency_code ,--bug 13812333 - pulling from rcv_sub instead of rcv_txn
614: rcv_sub.CURRENCY_CONVERSION_DATE , --bug 13812333 - pulling from rcv_sub instead of rcv_txn
615: rcv_txn.CURRENCY_CONVERSION_TYPE ,--bug 13812333 - pulling from rcv_sub instead of rcv_txn
616: /*bug13922293 pulling it from rcv_transactions */
617: rcv_sub.CURRENCY_CONVERSION_RATE ,--bug 13812333 - pulling from rcv_sub instead of rcv_txn
618: --trunc(rcv_txn.TRANSACTION_DATE) GL_Date, --Commented for the bug 12657430
619: trunc(rcv_sub.accounting_date) GL_Date, --Added for the bug 12657430
620: rcv_txn.DESTINATION_TYPE_CODE ,

Line 676: from rcv_transactions rcv_txn,

672: ,'Y' si_assets_addition_flag
673: ,'Y' insert_flag
674: ,rcv_sub.rcv_sub_ledger_id
675: ,type.cost_rate_flag
676: from rcv_transactions rcv_txn,
677: rcv_receiving_sub_ledger rcv_sub,
678: po_headers_all po_head,
679: po_lines_all po_line,
680: po_distributions_all po_dist,