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 1299: -- 1. Resource transactions are represented in WIP transactions table.

1295: ORDER BY MMT.inventory_item_id;
1296:
1297: -- Gets the actual lines from resource transactions.
1298: -- Points to note are -
1299: -- 1. Resource transactions are represented in WIP transactions table.
1300: -- 2. We assume the 'billable_item_id' to the inventory item for
1301: -- which we create actual lines.
1302: -- 3. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1303: -- not been imported.

Line 1321: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,

1317: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1318: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1319: l_wip_entity_id ACTUAL_SOURCE_ID,
1320: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
1321: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
1322: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
1323: CS_TXN_BILLING_TYPES TXBT
1324: WHERE WTXN.wip_entity_id = l_wip_entity_id
1325: AND WTXN.transaction_type IN( 1, 2, 3 )

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

1790: /****** Processing the Material transactions specific data - END *********/
1791:
1792:
1793:
1794: /****** Processing the Resource/WIP transactions specific data - START *********/
1795:
1796: -- DBMS_OUTPUT.put_line( 'processing RES ..' );
1797:
1798: if (lc_stat_level >= lc_debug_level) then

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

1796: -- DBMS_OUTPUT.put_line( 'processing RES ..' );
1797:
1798: if (lc_stat_level >= lc_debug_level) then
1799: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1800: 'Start: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1801: end if;
1802:
1803: -- Log bulk messages for all the generic warnings for the
1804: -- WIP transaction lines.

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

1909: END IF;
1910:
1911: if (lc_stat_level >= lc_debug_level) then
1912: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1913: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1914: end if;
1915:
1916: /****** Processing the Resource/WIP transactions specific data - END *********/
1917:

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

1912: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1913: 'END: Processing Resource/WIP transactions for the WIP job - ' || curr_WIP_job_rec.JOB_NAME);
1914: end if;
1915:
1916: /****** Processing the Resource/WIP transactions specific data - END *********/
1917:
1918: --DBMS_OUTPUT.put_line( 'before call to fnd save msgs' );
1919:
1920: -- Log all the warnings that may have been added to