APPS.BOMPBCMP dependencies on BOM_COMPARISON_TEMP

Line 54: INSERT INTO BOM_COMPARISON_TEMP

50: IMPEMENTED CODE 1 = Implemented only
51: 2 = Implemented and unimplemented
52: */
53:
54: INSERT INTO BOM_COMPARISON_TEMP
55: (SEQUENCE_ID,
56: ASSEMBLY_ID1,
57: ITEM_NUM,
58: COMPONENT_QUANTITY,

Line 151: UPDATE BOM_COMPARISON_TEMP T

147:
148: /* Now, update the rows in the temp table if there is a match with the
149: second bill of material */
150:
151: UPDATE BOM_COMPARISON_TEMP T
152: SET T.COMPONENT_SEQUENCE_ID2 =
153: (SELECT MIN(C.COMPONENT_SEQUENCE_ID)
154: FROM BOM_INVENTORY_COMPONENTS C
155: WHERE C.BILL_SEQUENCE_ID = BILL_SEQ_ID2

Line 159: FROM BOM_COMPARISON_TEMP T3

155: WHERE C.BILL_SEQUENCE_ID = BILL_SEQ_ID2
156: AND NVL(C.ECO_FOR_PRODUCTION,2) = 2
157: AND C.COMPONENT_ITEM_ID = T.ASSEMBLY_ID1
158: AND NOT EXISTS (SELECT 'x'
159: FROM BOM_COMPARISON_TEMP T3
160: WHERE T3.COMPONENT_SEQUENCE_ID2 =
161: C.COMPONENT_SEQUENCE_ID
162: AND T3.SEQUENCE_ID = T.SEQUENCE_ID)
163: AND DECODE(ITEM_NUM_CODE, 1, C.ITEM_NUM, T.ITEM_NUM) = T.ITEM_NUM

Line 258: FROM BOM_COMPARISON_TEMP T

254: to two rows in the first bill of material. */
255:
256: SELECT COUNT(*)
257: INTO COUNT_DUP
258: FROM BOM_COMPARISON_TEMP T
259: WHERE EXISTS
260: (SELECT NULL FROM BOM_COMPARISON_TEMP T2
261: WHERE T.ROWID < T2.ROWID
262: AND T.SEQUENCE_ID = T2.SEQUENCE_ID

Line 260: (SELECT NULL FROM BOM_COMPARISON_TEMP T2

256: SELECT COUNT(*)
257: INTO COUNT_DUP
258: FROM BOM_COMPARISON_TEMP T
259: WHERE EXISTS
260: (SELECT NULL FROM BOM_COMPARISON_TEMP T2
261: WHERE T.ROWID < T2.ROWID
262: AND T.SEQUENCE_ID = T2.SEQUENCE_ID
263: AND T.COMPONENT_SEQUENCE_ID2 = T2.COMPONENT_SEQUENCE_ID2)
264: AND T.SEQUENCE_ID = SEQ_ID;

Line 270: UPDATE BOM_COMPARISON_TEMP T

266: EXIT WHEN COUNT_DUP = 0;
267:
268: /* If duplicate matches are found, null out one of them */
269:
270: UPDATE BOM_COMPARISON_TEMP T
271: SET COMPONENT_SEQUENCE_ID2 = ''
272: WHERE EXISTS
273: (SELECT NULL FROM BOM_COMPARISON_TEMP T2
274: WHERE T.ROWID < T2.ROWID

Line 273: (SELECT NULL FROM BOM_COMPARISON_TEMP T2

269:
270: UPDATE BOM_COMPARISON_TEMP T
271: SET COMPONENT_SEQUENCE_ID2 = ''
272: WHERE EXISTS
273: (SELECT NULL FROM BOM_COMPARISON_TEMP T2
274: WHERE T.ROWID < T2.ROWID
275: AND T.SEQUENCE_ID = T2.SEQUENCE_ID
276: AND T.COMPONENT_SEQUENCE_ID2 = T2.COMPONENT_SEQUENCE_ID2)
277: AND T.SEQUENCE_ID = SEQ_ID;

Line 284: UPDATE BOM_COMPARISON_TEMP T

280:
281: /* Update the temp table to indicate whether columns that are not
282: comparison criteria are matches */
283:
284: UPDATE BOM_COMPARISON_TEMP T
285: SET (ITEM_NUM,
286: COMPONENT_QUANTITY,
287: OPERATION_SEQ_NUM,
288: EFFECTIVITY_DATE,

Line 324: INSERT INTO BOM_COMPARISON_TEMP

320:
321: /* Insert rows from the second bill of material that did not match anything
322: in the first bill of material */
323:
324: INSERT INTO BOM_COMPARISON_TEMP
325: (SEQUENCE_ID,
326: ASSEMBLY_ID2,
327: ITEM_NUM,
328: COMPONENT_QUANTITY,

Line 352: FROM BOM_COMPARISON_TEMP T2

348: WHERE BILL_SEQUENCE_ID = BILL_SEQ_ID2
349: AND NVL(C.ECO_FOR_PRODUCTION,2) = 2
350: AND NOT EXISTS
351: (SELECT 'x'
352: FROM BOM_COMPARISON_TEMP T2
353: WHERE T2.SEQUENCE_ID = SEQ_ID
354: AND T2.COMPONENT_SEQUENCE_ID2 = C.COMPONENT_SEQUENCE_ID)
355: AND ((IMPLEMENTED_CODE2 = 2)
356: OR

Line 426: DELETE FROM BOM_COMPARISON_TEMP

422: /* If we are only displaying differences, then delete all matches from
423: the temporary table */
424:
425: IF DIFF_CODE = 1 THEN
426: DELETE FROM BOM_COMPARISON_TEMP
427: WHERE SEQUENCE_ID = SEQ_ID
428: AND COMPONENT_SEQUENCE_ID1 IS NOT NULL
429: AND COMPONENT_SEQUENCE_ID2 IS NOT NULL;
430: END IF;