DBA Data[Home] [Help]

APPS.BOMPCCLT dependencies on MTL_SYSTEM_ITEMS

Line 16: mtl_system_items with cumulative lead time values.

12: explodes a given assembly into its components. Procedure
13: set_comp_lt computes cumulative lead times for all
14: purchased items. Procedure process_items computes cum lead
15: times for a given bom level. Procedure update_lt updates
16: mtl_system_items with cumulative lead time values.
17: Required Tables :
18: BOM_PARAMETERS
19: BOM_INVENTORY_COMPONENTS
20: BOM_BILL_OF_MATERIALS

Line 22: MTL_SYSTEM_ITEMS

18: BOM_PARAMETERS
19: BOM_INVENTORY_COMPONENTS
20: BOM_BILL_OF_MATERIALS
21: BOM_LOW_LEVEL_CODES
22: MTL_SYSTEM_ITEMS
23: History
24: 20-Feb-1996 Manu Chadha
25: -Added the MTL.ORGANIZATION_ID = org_id; line to to
26: update_lc as a fix for bug#343531

Line 30: in mtl_system_items directly

26: update_lc as a fix for bug#343531
27: 02-Oct-1997 Rob Yee
28: Streamline for performance by using
29: recursion for explosion and updating leadtimes
30: in mtl_system_items directly
31: 21-Aug-1998 Mani
32: Added unit number and changed SQL statements
33: to implement Serial Effectivity.
34: 13-May-2004 Rahul Chitko

Line 63: FROM MTL_SYSTEM_ITEMS MTL2,

59: l_FatalError exception;
60: Cursor l_comps_csr (p_org_id number, p_item_id number, p_unit_number varchar2,
61: p_eff_date date) is
62: SELECT COM.COMPONENT_ITEM_ID
63: FROM MTL_SYSTEM_ITEMS MTL2,
64: BOM_INVENTORY_COMPONENTS COM,
65: MTL_SYSTEM_ITEMS MTL1,
66: BOM_BILL_OF_MATERIALS BOM
67: WHERE NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'XXXXXXXXXXX') =

Line 65: MTL_SYSTEM_ITEMS MTL1,

61: p_eff_date date) is
62: SELECT COM.COMPONENT_ITEM_ID
63: FROM MTL_SYSTEM_ITEMS MTL2,
64: BOM_INVENTORY_COMPONENTS COM,
65: MTL_SYSTEM_ITEMS MTL1,
66: BOM_BILL_OF_MATERIALS BOM
67: WHERE NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'XXXXXXXXXXX') =
68: NVL(p_alternate_bom_code,'XXXXXXXXXXX')
69: AND COM.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID

Line 221: From bom_lists bl, mtl_system_items msi

217: l_stmt_num varchar2(3);
218: cursor l_list_csr is
219: Select bl.assembly_item_id,
220: bl.conc_flex_string
221: From bom_lists bl, mtl_system_items msi
222: Where bl.sequence_id = roll_id
223: and msi.organization_id = org_id
224: and msi.inventory_item_id = bl.assembly_item_id
225: and (unit_number is NOT NULL

Line 349: from mtl_system_items MTL,

345: 2, 0,
346: NVL(MTL.FULL_LEAD_TIME, 0)) FULL_LEAD_TIME,
347: MTL.PLANNING_MAKE_BUY_CODE,
348: MTL.bom_item_type bom_item_type
349: from mtl_system_items MTL,
350: bom_low_level_codes LLC
351: where LLC.ROLLUP_ID = roll_id
352: AND LLC.LOW_LEVEL_CODE = p_level
353: AND MTL.INVENTORY_ITEM_ID = LLC.INVENTORY_ITEM_ID

Line 363: FROM MTL_SYSTEM_ITEMS MTL2,

359: p_eff_date date) is
360: SELECT NVL(MTL2.CUMULATIVE_TOTAL_LEAD_TIME, 0) CUMULATIVE_TOTAL_LEAD_TIME,
361: NVL(MTL2.CUM_MANUFACTURING_LEAD_TIME, 0) CUM_MANUFACTURING_LEAD_TIME,
362: COM.OPERATION_SEQ_NUM
363: FROM MTL_SYSTEM_ITEMS MTL2,
364: BOM_INVENTORY_COMPONENTS COM,
365: MTL_SYSTEM_ITEMS MTL1,
366: BOM_BILL_OF_MATERIALS BOM
367: WHERE BOM.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 365: MTL_SYSTEM_ITEMS MTL1,

361: NVL(MTL2.CUM_MANUFACTURING_LEAD_TIME, 0) CUM_MANUFACTURING_LEAD_TIME,
362: COM.OPERATION_SEQ_NUM
363: FROM MTL_SYSTEM_ITEMS MTL2,
364: BOM_INVENTORY_COMPONENTS COM,
365: MTL_SYSTEM_ITEMS MTL1,
366: BOM_BILL_OF_MATERIALS BOM
367: WHERE BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
368: AND COM.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
369: AND BOM.ORGANIZATION_ID = p_org_id

Line 469: Update mtl_system_items set

465: l_last_updated_by := NVL(fnd_global.user_id, -1); -- BUG 4990802
466: l_last_update_login := NVL(fnd_global.login_id, -1); -- BUG 4990802
467: /* Modified update statement to include the attributes last_update_date, last_updated_by, last_update_login for BUG 4990802 */
468: if (X_include_in_rollup ='Y') then
469: Update mtl_system_items set
470: CUMULATIVE_TOTAL_LEAD_TIME = l_assy_rec.total_lead_time + l_ctlt ,
471: CUM_MANUFACTURING_LEAD_TIME = l_assy_rec.full_lead_time + l_cmlt ,
472: REQUEST_ID = req_id,
473: PROGRAM_APPLICATION_ID = prgm_app_id,