DBA Data[Home] [Help]

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 361: wip_transactions wt

357: , l_ae_txn_rec.encum_account
358: , l_ae_txn_rec.encum_amount
359: --}
360: FROM
361: wip_transactions wt
362: WHERE
363: wt.transaction_id = i_transaction_id;
364:
365: SELECT entity_type

Line 377: wip_transactions wt

373: INTO
374: l_ae_txn_rec.exp_item
375: FROM
376: mtl_system_items msi,
377: wip_transactions wt
378: WHERE
379: msi.inventory_item_id = wt.primary_item_id AND
380: wt.organization_id = msi.organization_id AND
381: wt.transaction_id = i_transaction_id;

Line 483: /* Bug 12795089 : Category is not required for wip transactions, which use

479: -- Get the category for the item for the org
480: -- This will be used later to determine the category accounts from MFCA
481: -----------------------------------------------------------------------------
482:
483: /* Bug 12795089 : Category is not required for wip transactions, which use
484: accounts defined for the job
485: IF ((l_ae_txn_rec.txn_type_id = 6 and l_ae_txn_rec.txn_type_flag = 'WIP')
486: or (l_ae_txn_rec.inventory_item_id is NULL and l_ae_txn_rec.txn_type_flag = 'WIP')) THEN */
487:

Line 1206: -- WIP transactions.

1202:
1203: END create_inv_ae_lines;
1204:
1205: -- ===================================================================
1206: -- WIP transactions.
1207: -- ===================================================================
1208: procedure wip_cost_txn(
1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

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

8409: /* currency stuff !! */
8410: /* dont have material ovhd variance account, so using material variance acct */
8411:
8412: -- ===================================================================
8413: -- Controls line creation for WIP transactions.
8414: -- ===================================================================
8415: procedure create_wip_ae_lines(
8416: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8417: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,

Line 8526: from wip_transactions wt,

8522: select
8523: we.wip_entity_id
8524: into
8525: l_ae_line_rec.wip_entity_id
8526: from wip_transactions wt,
8527: wip_entities we
8528: where we.wip_entity_id = wt.wip_entity_id
8529: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8530:

Line 8627: FROM rcv_parameters RCV , wip_transactions WT

8623: /* Accounting line type for credit will be Receiving Inspection */
8624:
8625: SELECT RCV.receiving_account_id
8626: INTO l_ae_line_rec.account
8627: FROM rcv_parameters RCV , wip_transactions WT
8628: WHERE WT.transaction_id = i_ae_txn_rec.transaction_id
8629: AND WT.organization_id = RCV.organization_id;
8630:
8631: /* Call Insert Account.

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

8909:
8910: END create_wip_ae_lines;
8911:
8912: -- ===================================================================
8913: -- Get Account from the entities (Used in WIP transactions).
8914: -- ===================================================================
8915: procedure get_accts(
8916: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8917: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

Line 8987: from wip_transactions wt,

8983: wt.line_id
8984: into l_entity_type,
8985: l_wip_entity_id,
8986: l_line_id
8987: from wip_transactions wt,
8988: wip_entities we
8989: where we.wip_entity_id = wt.wip_entity_id
8990: and wt.transaction_id = i_ae_txn_rec.transaction_id;
8991: