DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on WIP_TRANSACTIONS

Line 7726: -- 1. Resource transactions are represented in WIP transactions table.

7722: ORDER BY wro.inventory_item_id;
7723:
7724: -- Gets the estimate lines from resource transactions.
7725: -- Points to note are -
7726: -- 1. Resource transactions are represented in WIP transactions table.
7727: -- 2. We assume the 'billable_item_id' to the inventory item for
7728: -- which we create estimate lines.
7729: -- 3. The view CSD_ESTIMATES_FROM_WIP_V considers only the WIP jobs that have
7730: -- not been imported.

Line 7746: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,

7742: G_ESTIMATE_SOURCE_CODE_WIP ESTIMATE_SOURCE_CODE,
7743: l_wip_entity_id ESTIMATE_SOURCE_ID,
7744: wtxn.operation_seq_num OPERATION_SEQ_NUM,
7745: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
7746: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
7747: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
7748: CS_TXN_BILLING_TYPES TXBT
7749: WHERE WTXN.wip_entity_id = l_wip_entity_id
7750: AND WTXN.transaction_type IN( 1, 2, 3 )

Line 8310: /****** Processing the Resource/WIP transactions specific data - START *********/

8306: /****** Processing the Material transactions specific data - END *********/
8307:
8308:
8309:
8310: /****** Processing the Resource/WIP transactions specific data - START *********/
8311:
8312: if (lc_stat_level >= lc_debug_level) then
8313: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8314: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);

Line 8314: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);

8310: /****** Processing the Resource/WIP transactions specific data - START *********/
8311:
8312: if (lc_stat_level >= lc_debug_level) then
8313: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8314: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8315: end if;
8316: -- Now, we process the WIP transaction lines (for resources) for all
8317: -- the WIP jobs. Getting the table for all the lines.
8318: DECLARE

Line 8402: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);

8398: END;
8399:
8400: if (lc_stat_level >= lc_debug_level) then
8401: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8402: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
8403: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8404: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8405: end if;
8406:

Line 8407: /****** Processing the Resource/WIP transactions specific data - END *********/

8403: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8404: 'Estimate line count = ' || l_estimate_lines_tbl.COUNT);
8405: end if;
8406:
8407: /****** Processing the Resource/WIP transactions specific data - END *********/
8408:
8409: -- PO number from RO should be defaulted on estimate lines created from WIP.
8410: begin
8411: select default_po_num