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 379: BOM_SMALL_IMPL_TEMP BITT,

375: BBM.ORGANIZATION_ID OI,
376: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
377: BIC.TO_END_ITEM_UNIT_NUMBER TUN
378: FROM
379: BOM_SMALL_IMPL_TEMP BITT,
380: BOM_INVENTORY_COMPONENTS BIC,
381: BOM_BILL_OF_MATERIALS BBM,
382: MTL_SYSTEM_ITEMS MSI
383: where bic.pk1_value = BITT.PARENT_ITEM_ID and

Line 842: /*INSERT INTO BOM_SMALL_IMPL_TEMP

838:
839:
840: FORALL i IN 1..l_bulk_count
841: -- commented for Bug #4070863 and added below
842: /*INSERT INTO BOM_SMALL_IMPL_TEMP
843: (LOWEST_ITEM_ID,
844: CURRENT_ITEM_ID,
845: PARENT_ITEM_ID,
846: ALTERNATE_DESIGNATOR,

Line 896: INSERT INTO BOM_SMALL_IMPL_TEMP

892: -1,
893: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
894: to_date(impl_date, 'YYYY/MM/DD HH24:MI')); */
895:
896: INSERT INTO BOM_SMALL_IMPL_TEMP
897: (LOWEST_ITEM_ID,
898: CURRENT_ITEM_ID,
899: PARENT_ITEM_ID,
900: ALTERNATE_DESIGNATOR,

Line 955: FROM BOM_SMALL_IMPL_TEMP

951: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
952: FROM DUAL
953: WHERE NOT EXISTS
954: ( SELECT 'X'
955: FROM BOM_SMALL_IMPL_TEMP
956: WHERE LOWEST_ITEM_ID = l_lid1(i)
957: AND CURRENT_ITEM_ID = l_pid1(i)
958: AND PARENT_ITEM_ID = l_aid1(i)
959: AND ALTERNATE_DESIGNATOR = l_abd1(i)

Line 1045: BOM_SMALL_IMPL_TEMP BITT,

1041: BBM.ORGANIZATION_ID OI,
1042: BIC.FROM_END_ITEM_UNIT_NUMBER FUN,
1043: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1044: FROM
1045: BOM_SMALL_IMPL_TEMP BITT,
1046: BOM_INVENTORY_COMPONENTS BIC,
1047: BOM_BILL_OF_MATERIALS BBM,
1048: MTL_SYSTEM_ITEMS MSI
1049: where bic.pk1_value = BITT.PARENT_ITEM_ID and

Line 1453: /*INSERT INTO BOM_SMALL_IMPL_TEMP

1449: -- Insert the Second table values using FORALL.
1450:
1451: FORALL i IN 1..l_bulk_count
1452: -- commented for Bug #4070863 and added below
1453: /*INSERT INTO BOM_SMALL_IMPL_TEMP
1454: (LOWEST_ITEM_ID,
1455: CURRENT_ITEM_ID,
1456: PARENT_ITEM_ID,
1457: ALTERNATE_DESIGNATOR,

Line 1507: INSERT INTO BOM_SMALL_IMPL_TEMP

1503: -1,
1504: decode(length(l_sc1(i)), 7,null,substrb(l_sc1(i),1,length(l_sc1(i))-7)),
1505: to_date(impl_date, 'YYYY/MM/DD HH24:MI')); */
1506:
1507: INSERT INTO BOM_SMALL_IMPL_TEMP
1508: (LOWEST_ITEM_ID,
1509: CURRENT_ITEM_ID,
1510: PARENT_ITEM_ID,
1511: ALTERNATE_DESIGNATOR,

Line 1566: FROM BOM_SMALL_IMPL_TEMP

1562: to_date(impl_date, 'YYYY/MM/DD HH24:MI')
1563: FROM DUAL
1564: WHERE NOT EXISTS
1565: ( SELECT 'X'
1566: FROM BOM_SMALL_IMPL_TEMP
1567: WHERE LOWEST_ITEM_ID = l_lid1(i)
1568: AND CURRENT_ITEM_ID = l_pid1(i)
1569: AND PARENT_ITEM_ID = l_aid1(i)
1570: AND ALTERNATE_DESIGNATOR = l_abd1(i)