APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on WIP_TRANSACTIONS

Line 59: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES

55: -- Fetches records that have the following warning -
56: -- 1. Billing item not defined for Resource.
57: CURSOR C_Resource_Item_Not_Defined IS
58: SELECT DISTINCT RES.resource_code
59: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES
60: WHERE WTXN.wip_entity_id = p_wip_entity_id
61: AND RES.resource_id = WTXN.resource_id
62: AND RES.billable_item_id IS NULL;
63:

Line 73: FROM WIP_TRANSACTIONS WTXN,

69: SUM( NVL( WTXN.primary_quantity, 0 )) QUANTITY,
70: MSIW.concatenated_segments WIP_ITEM_NAME,
71: MSID.inventory_item_id DEPOT_ITEM_ID,
72: MSID.material_billable_flag BILLING_TYPE
73: FROM WIP_TRANSACTIONS WTXN,
74: BOM_RESOURCES RES,
75: MTL_SYSTEM_ITEMS_KFV MSIW,-- For WIP organization
76: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
77: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization

Line 94: FROM WIP_TRANSACTIONS WTXN,

90: CURSOR C_Resource_Txn_Billing_Type IS
91: SELECT RES.billable_item_id INVENTORY_ITEM_ID,
92: SUM( NVL( WTXN.primary_quantity, 0 )) QUANTITY,
93: MSID.concatenated_segments DEPOT_ITEM_NAME
94: FROM WIP_TRANSACTIONS WTXN,
95: BOM_RESOURCES RES,
96: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
97: WHERE WTXN.wip_entity_id = p_wip_entity_id
98: AND RES.resource_id = WTXN.resource_id

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

1352: --bug#9557061
1353:
1354: -- Gets the actual lines from resource transactions.
1355: -- Points to note are -
1356: -- 1. Resource transactions are represented in WIP transactions table.
1357: -- 2. We assume the 'billable_item_id' to the inventory item for
1358: -- which we create actual lines.
1359: -- 3. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1360: -- not been imported.

Line 1378: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,

1374: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1375: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1376: l_wip_entity_id ACTUAL_SOURCE_ID,
1377: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
1378: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
1379: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
1380: CS_TXN_BILLING_TYPES TXBT
1381: WHERE WTXN.wip_entity_id = l_wip_entity_id
1382: AND WTXN.transaction_type IN( 1, 2, 3 )

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

1869: /****** Processing the Material transactions specific data - END *********/
1870:
1871:
1872:
1873: /****** Processing the Resource/WIP transactions specific data - START *********/
1874:
1875: -- DBMS_OUTPUT.put_line( 'processing RES ..' );
1876:
1877: if (lc_stat_level >= lc_debug_level) then

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

1875: -- DBMS_OUTPUT.put_line( 'processing RES ..' );
1876:
1877: if (lc_stat_level >= lc_debug_level) then
1878: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1879: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1880: end if;
1881:
1882: -- Log bulk messages for all the generic warnings for the
1883: -- WIP transaction lines.

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

1988: END IF;
1989:
1990: if (lc_stat_level >= lc_debug_level) then
1991: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1992: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1993: end if;
1994:
1995: /****** Processing the Resource/WIP transactions specific data - END *********/
1996:

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

1991: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1992: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1993: end if;
1994:
1995: /****** Processing the Resource/WIP transactions specific data - END *********/
1996:
1997: --DBMS_OUTPUT.put_line( 'before call to fnd save msgs' );
1998:
1999: -- Log all the warnings that may have been added to