APPS.BOMPEXPL dependencies on BOM_LISTS

Line 40: | list_id unique id for lists in bom_lists for range

36: | std_comp_flag 1 - explode only standard components
37: | 2 - all components
38: | expl_qty explosion quantity
39: | item_id item id of asembly to explode
40: | list_id unique id for lists in bom_lists for range
41: | report_option 1 - cost rollup with report
42: | 2 - cost rollup no report
43: | 3 - temp cost rollup with report
44: | cst_rlp_id rollup_id

Line 66: 02/10/94 Shreyas Shah added multi-org capability from bom_lists

62: | error_code error code out. returns sql error code
63: | if sql error
64: | Revision
65: Shreyas Shah creation
66: 02/10/94 Shreyas Shah added multi-org capability from bom_lists
67: max_bom_levels of all orgs for multi-org
68: 03/24/94 Shreyas Shah added 4 to module parameter so that
69: if ATO calls it dont commit but if CST
70: calls it then commit data

Line 1245: Bom_Lists bl

1241: bom.common_bill_sequence_id,
1242: msi.bom_item_type
1243: From mtl_system_items msi,
1244: Bom_Bill_Of_Materials bom,
1245: Bom_Lists bl
1246: Where bl.sequence_id = list_id
1247: And bom.assembly_item_id = bl.assembly_item_id
1248: And bom.organization_id = org_id
1249: And nvl(bom.alternate_bom_designator, 'PRIMARY ALTERNATE') =

Line 1270: Bom_Lists bl

1266: msi.bom_item_type
1267: FROM
1268: mtl_system_items msi,
1269: Bom_Bill_Of_Materials bom,
1270: Bom_Lists bl
1271: WHERE
1272: bl.sequence_id = list_id And
1273: bom.assembly_item_id = bl.assembly_item_id And
1274: bom.organization_id = org_id And

Line 1292: Bom_Lists bl

1288: msi.bom_item_type
1289: FROM
1290: mtl_system_items msi,
1291: Bom_Bill_Of_Materials bom,
1292: Bom_Lists bl
1293: WHERE
1294: bl.sequence_id = list_id And
1295: bom.assembly_item_id = bl.assembly_item_id And
1296: bom.organization_id = org_id And

Line 1874: FROM BOM_LISTS BL

1870: BL.ASSEMBLY_ITEM_ID,
1871: NULL,
1872: to_char(BL.ASSEMBLY_ITEM_ID),
1873: 2
1874: FROM BOM_LISTS BL
1875: WHERE BL.SEQUENCE_ID = list_id
1876: AND BL.ALTERNATE_DESIGNATOR IS NULL
1877: AND NOT EXISTS (SELECT 'NO BILL' FROM BOM_BILL_OF_MATERIALS BOM
1878: WHERE BOM.ORGANIZATION_ID =

Line 2013: ** if single level rollup, delete items that do not exist in bom_lists

2009: WHERE GROUP_ID = grp_id
2010: GROUP BY COMPONENT_ITEM_ID;
2011:
2012: /*
2013: ** if single level rollup, delete items that do not exist in bom_lists
2014: */
2015:
2016: IF (rollup_option = 1) THEN
2017: stmt_num := 6;

Line 2021: FROM BOM_LISTS BL

2017: stmt_num := 6;
2018:
2019: DELETE CST_LOW_LEVEL_CODES CLLC
2020: WHERE NOT EXISTS (SELECT 'Item in list'
2021: FROM BOM_LISTS BL
2022: WHERE SEQUENCE_ID = list_id
2023: AND BL.ASSEMBLY_ITEM_ID = CLLC.INVENTORY_ITEM_ID)
2024: AND ROLLUP_ID = cst_rlp_id;
2025: