DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on BOM_DEPENDENT_DESC_ELEMENTS

Line 6167: INSERT INTO bom_dependent_desc_elements

6163: OR itm_type = option_class)
6164: THEN
6165: sql_stmt_num := 55;
6166:
6167: INSERT INTO bom_dependent_desc_elements
6168: (bill_sequence_id,
6169: element_name,
6170: last_update_date,
6171: last_updated_by,

Line 6191: FROM bom_dependent_desc_elements bdde

6187: NULL,
6188: fnd_global.conc_program_id,
6189: sysdate,
6190: fnd_global.conc_request_id
6191: FROM bom_dependent_desc_elements bdde
6192: WHERE bdde.bill_sequence_id = x_from_sequence_id
6193: AND ((itm_type = model
6194: AND EXISTS (
6195: SELECT NULL

Line 11594: INSERT INTO bom_dependent_desc_elements

11590: OR itm_type = option_class) AND p_cpy_past_eff_comps = 'Y' -- Copy desc elements only once
11591: THEN
11592: sql_stmt_num := 55;
11593:
11594: INSERT INTO bom_dependent_desc_elements
11595: (bill_sequence_id,
11596: element_name,
11597: last_update_date,
11598: last_updated_by,

Line 11618: FROM bom_dependent_desc_elements bdde

11614: NULL,
11615: fnd_global.conc_program_id,
11616: sysdate,
11617: fnd_global.conc_request_id
11618: FROM bom_dependent_desc_elements bdde
11619: WHERE bdde.bill_sequence_id = x_from_sequence_id
11620: AND ((itm_type = model
11621: AND EXISTS (
11622: SELECT NULL