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 1864: FROM BOM_LISTS BL

1860: BL.ASSEMBLY_ITEM_ID,
1861: NULL,
1862: to_char(BL.ASSEMBLY_ITEM_ID),
1863: 2
1864: FROM BOM_LISTS BL
1865: WHERE BL.SEQUENCE_ID = list_id
1866: AND BL.ALTERNATE_DESIGNATOR IS NULL
1867: AND NOT EXISTS (SELECT 'NO BILL' FROM BOM_BILL_OF_MATERIALS BOM
1868: WHERE BOM.ORGANIZATION_ID =

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

1988: WHERE GROUP_ID = grp_id
1989: GROUP BY COMPONENT_ITEM_ID;
1990:
1991: /*
1992: ** if single level rollup, delete items that do not exist in bom_lists
1993: */
1994:
1995: IF (rollup_option = 1) THEN
1996: stmt_num := 6;

Line 2000: FROM BOM_LISTS BL

1996: stmt_num := 6;
1997:
1998: DELETE CST_LOW_LEVEL_CODES CLLC
1999: WHERE NOT EXISTS (SELECT 'Item in list'
2000: FROM BOM_LISTS BL
2001: WHERE SEQUENCE_ID = list_id
2002: AND BL.ASSEMBLY_ITEM_ID = CLLC.INVENTORY_ITEM_ID)
2003: AND ROLLUP_ID = cst_rlp_id;
2004: