APPS.BOMPIINQ dependencies on BOM_SMALL_IMPL_TEMP

Line 17: | use value from sequence bom_small_impl_temp_s

13: | imploders calls the correct imploder based on the
14: | # of levels to implode.
15: | Parameters: org_id organization_id
16: | sequence_id unique value to identify current implosion
17: | use value from sequence bom_small_impl_temp_s
18: | levels_to_implode
19: | eng_mfg_flag 1 - BOM
20: | 2 - ENG
21: | impl_flag 1 - implemented only

Line 161: /*INSERT INTO BOM_SMALL_IMPL_TEMP

157:
158:
159: if item_found then
160: -- commented for Bug #4070863 and added below
161: /*INSERT INTO BOM_SMALL_IMPL_TEMP
162: ( SEQUENCE_ID,
163: LOWEST_ITEM_ID,
164: CURRENT_ITEM_ID,
165: PARENT_ITEM_ID,

Line 194: INSERT INTO BOM_SMALL_IMPL_TEMP

190: sysdate,
191: -1,
192: to_date(impl_date, 'YYYY/MM/DD HH24:MI')); */
193:
194: INSERT INTO BOM_SMALL_IMPL_TEMP
195: ( SEQUENCE_ID,
196: LOWEST_ITEM_ID,
197: CURRENT_ITEM_ID,
198: PARENT_ITEM_ID,

Line 231: FROM BOM_SMALL_IMPL_TEMP

227: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
228: FROM DUAL
229: WHERE NOT EXISTS
230: ( SELECT 'X'
231: FROM BOM_SMALL_IMPL_TEMP
232: WHERE SEQUENCE_ID = sequence_id
233: AND LOWEST_ITEM_ID = item_id
234: AND CURRENT_ITEM_ID = item_id
235: AND PARENT_ITEM_ID = item_id

Line 366: BOM_SMALL_IMPL_TEMP BITT,

362: BBM.ORGANIZATION_ID OI,
363: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
364: BIC.TO_END_ITEM_UNIT_NUMBER TUN
365: FROM
366: BOM_SMALL_IMPL_TEMP BITT,
367: BOM_INVENTORY_COMPONENTS BIC,
368: BOM_BILL_OF_MATERIALS BBM,
369: MTL_SYSTEM_ITEMS MSI
370: where bitt.current_level = 0

Line 827: /*INSERT INTO BOM_SMALL_IMPL_TEMP

823:
824:
825: FORALL i IN 1..l_bulk_count
826: -- commented for Bug #4070863 and added below
827: /*INSERT INTO BOM_SMALL_IMPL_TEMP
828: (LOWEST_ITEM_ID,
829: CURRENT_ITEM_ID,
830: PARENT_ITEM_ID,
831: ALTERNATE_DESIGNATOR,

Line 881: INSERT INTO BOM_SMALL_IMPL_TEMP

877: -1,
878: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
879: to_date(impl_date, 'YYYY/MM/DD HH24:MI')); */
880:
881: INSERT INTO BOM_SMALL_IMPL_TEMP
882: (LOWEST_ITEM_ID,
883: CURRENT_ITEM_ID,
884: PARENT_ITEM_ID,
885: ALTERNATE_DESIGNATOR,

Line 940: FROM BOM_SMALL_IMPL_TEMP

936: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
937: FROM DUAL
938: WHERE NOT EXISTS
939: ( SELECT 'X'
940: FROM BOM_SMALL_IMPL_TEMP
941: WHERE LOWEST_ITEM_ID = l_lid1(i)
942: AND CURRENT_ITEM_ID = l_pid1(i)
943: AND PARENT_ITEM_ID = l_aid1(i)
944: AND ALTERNATE_DESIGNATOR = l_abd1(i)

Line 1017: BOM_SMALL_IMPL_TEMP BITT,

1013: BBM.ORGANIZATION_ID OI,
1014: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
1015: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1016: FROM
1017: BOM_SMALL_IMPL_TEMP BITT,
1018: BOM_INVENTORY_COMPONENTS BIC,
1019: BOM_BILL_OF_MATERIALS BBM,
1020: MTL_SYSTEM_ITEMS MSI
1021: where

Line 1424: /*INSERT INTO BOM_SMALL_IMPL_TEMP

1420: -- Insert the Second table values using FORALL.
1421:
1422: FORALL i IN 1..l_bulk_count
1423: -- commented for Bug #4070863 and added below
1424: /*INSERT INTO BOM_SMALL_IMPL_TEMP
1425: (LOWEST_ITEM_ID,
1426: CURRENT_ITEM_ID,
1427: PARENT_ITEM_ID,
1428: ALTERNATE_DESIGNATOR,

Line 1478: INSERT INTO BOM_SMALL_IMPL_TEMP

1474: -1,
1475: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
1476: to_date(impl_date, 'YYYY/MM/DD HH24:MI')); */
1477:
1478: INSERT INTO BOM_SMALL_IMPL_TEMP
1479: (LOWEST_ITEM_ID,
1480: CURRENT_ITEM_ID,
1481: PARENT_ITEM_ID,
1482: ALTERNATE_DESIGNATOR,

Line 1537: FROM BOM_SMALL_IMPL_TEMP

1533: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
1534: FROM DUAL
1535: WHERE NOT EXISTS
1536: ( SELECT 'X'
1537: FROM BOM_SMALL_IMPL_TEMP
1538: WHERE LOWEST_ITEM_ID = l_lid1(i)
1539: AND CURRENT_ITEM_ID = l_pid1(i)
1540: AND PARENT_ITEM_ID = l_aid1(i)
1541: AND ALTERNATE_DESIGNATOR = l_abd1(i)