APPS.CSTPAPBR dependencies on WIP_TRANSACTIONS

Line 9: | MTL_MATERIAL_TRANSACTIONS or WIP_TRANSACTIONS depending on the type of txn |

5:
6: /*============================================================================+
7: | This procedure is called by the Accounting Package for the Accounting Lib. |
8: | It first gets the details of the transaction from either |
9: | MTL_MATERIAL_TRANSACTIONS or WIP_TRANSACTIONS depending on the type of txn |
10: | that is being processed. The appropriate procedure is then called to create |
11: | the accounting entry lines in the form of a PL/SQL table. |
12: |============================================================================*/
13:

Line 355: wip_transactions wt

351: l_ae_txn_rec.flow_schedule,
352: l_ae_txn_rec.line_id,
353: l_ae_txn_rec.exp_item
354: FROM
355: wip_transactions wt
356: WHERE
357: wt.transaction_id = i_transaction_id;
358:
359: SELECT entity_type

Line 371: wip_transactions wt

367: INTO
368: l_ae_txn_rec.exp_item
369: FROM
370: mtl_system_items msi,
371: wip_transactions wt
372: WHERE
373: msi.inventory_item_id = wt.primary_item_id AND
374: wt.organization_id = msi.organization_id AND
375: wt.transaction_id = i_transaction_id;

Line 988: -- WIP transactions.

984:
985: END create_inv_ae_lines;
986:
987: -- ===================================================================
988: -- WIP transactions.
989: -- ===================================================================
990: procedure wip_cost_txn(
991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

Line 8030: -- Controls line creation for WIP transactions.

8026: /* currency stuff !! */
8027: /* dont have material ovhd variance account, so using material variance acct */
8028:
8029: -- ===================================================================
8030: -- Controls line creation for WIP transactions.
8031: -- ===================================================================
8032: procedure create_wip_ae_lines(
8033: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8034: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,

Line 8140: from wip_transactions wt,

8136: select
8137: we.wip_entity_id
8138: into
8139: l_ae_line_rec.wip_entity_id
8140: from wip_transactions wt,
8141: wip_entities we
8142: where we.wip_entity_id = wt.wip_entity_id
8143: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8144:

Line 8241: FROM rcv_parameters RCV , wip_transactions WT

8237: /* Accounting line type for credit will be Receiving Inspection */
8238:
8239: SELECT RCV.receiving_account_id
8240: INTO l_ae_line_rec.account
8241: FROM rcv_parameters RCV , wip_transactions WT
8242: WHERE WT.transaction_id = i_ae_txn_rec.transaction_id
8243: AND WT.organization_id = RCV.organization_id;
8244:
8245: /* Call Insert Account.

Line 8472: -- Get Account from the entities (Used in WIP transactions).

8468:
8469: END create_wip_ae_lines;
8470:
8471: -- ===================================================================
8472: -- Get Account from the entities (Used in WIP transactions).
8473: -- ===================================================================
8474: procedure get_accts(
8475: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8476: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

Line 8546: from wip_transactions wt,

8542: wt.line_id
8543: into l_entity_type,
8544: l_wip_entity_id,
8545: l_line_id
8546: from wip_transactions wt,
8547: wip_entities we
8548: where we.wip_entity_id = wt.wip_entity_id
8549: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8550: