APPS.BOMPLDCB dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 177: BOM_BILL_OF_MTLS_INTERFACE b3

173: b1.component_quantity
174: from
175: BOM_INVENTORY_COMPS_INTERFACE b1,
176: BOM_INVENTORY_COMPS_INTERFACE b2,
177: BOM_BILL_OF_MTLS_INTERFACE b3
178: where
179: b1.bill_sequence_id = b2.bill_sequence_id
180: and b1.component_sequence_id <> b2.component_sequence_id
181: and b1.operation_seq_num = b2.operation_seq_num

Line 255: table_name := 'BOM_BILL_OF_MTLS_INTERFACE ';

251: BEGIN
252: /*
253: ** load bom header interface table
254: */
255: table_name := 'BOM_BILL_OF_MTLS_INTERFACE ';
256: stmt_num := 10;
257: insert into BOM_BILL_OF_MTLS_INTERFACE(
258: assembly_item_id,
259: organization_id,

Line 257: insert into BOM_BILL_OF_MTLS_INTERFACE(

253: ** load bom header interface table
254: */
255: table_name := 'BOM_BILL_OF_MTLS_INTERFACE ';
256: stmt_num := 10;
257: insert into BOM_BILL_OF_MTLS_INTERFACE(
258: assembly_item_id,
259: organization_id,
260: alternate_bom_designator,
261: last_update_date,

Line 346: ** bill sequence id in the BOM_BILL_OF_MTLS_INTERFACE

342:
343:
344: /*
345: ** Update the common bill sequence id equal to the
346: ** bill sequence id in the BOM_BILL_OF_MTLS_INTERFACE
347: */
348:
349: /*
350: ** This is not required since it is being taken care in

Line 355: ** update BOM_BILL_OF_MTLS_INTERFACE b

351: ** the insert statement itself using the currval of the
352: ** sequence.
353: **
354: ** stmt_num := 20;
355: ** update BOM_BILL_OF_MTLS_INTERFACE b
356: ** set common_bill_sequence_id = bill_sequence_id
357: ** where (b.common_bill_sequence_id =1 or
358: ** b.common_bill_sequence_id is NULL )
359: ** and b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 579: bom_bill_of_mtls_interface b

575: bom_inventory_components ic1,
576: mtl_demand d1, /*Option */
577: mtl_demand d2, /* Parent-Model */
578: mtl_demand d3, /* parent-Component */
579: bom_bill_of_mtls_interface b
580: where ic1.component_sequence_id =( /* Refer bug 625484. component_sequence_id */
581: select component_sequence_id /* in d1 points to components in validation */
582: from bom_inventory_components bic /* so,we need to map these to Mfg org. For */
583: where bill_sequence_id = ( /* this we find the assembly to which */

Line 750: bom_bill_of_mtls_interface b1,

746: seq id for later use */
747: ic1.supply_subinventory,
748: ic1.supply_locator_id
749: from
750: bom_bill_of_mtls_interface b1,
751: mtl_demand d2, /* Model-Parent */
752: mtl_demand d1, /* Standard Mandatory comp */
753: mtl_system_items si1,
754: bom_bill_of_materials b,

Line 919: bom_bill_of_mtls_interface b,

915: seq id for later use */
916: ic1.supply_subinventory,
917: ic1.supply_locator_id
918: from
919: bom_bill_of_mtls_interface b,
920: mtl_demand d2, /* Model */
921: mtl_demand d1, /* Option Classes */
922: mtl_demand d3, /* parent component */
923: bom_inventory_components ic1

Line 1087: bom_bill_of_mtls_interface b

1083: to save the model component
1084: seq id for later use */
1085: from
1086: mtl_demand d2,
1087: bom_bill_of_mtls_interface b
1088: where d2.config_status = 20
1089: and d2.demand_source_line = b.demand_source_line
1090: and d2.demand_source_type = b.demand_source_type
1091: and d2.demand_source_header_id = b.demand_source_header_id

Line 2050: BOM_BILL_OF_MTLS_INTERFACE bi

2046: (select 'op seq exists in config routing'
2047: from
2048: BOM_OP_SEQUENCES_INTERFACE oi,
2049: BOM_OP_ROUTINGS_INTERFACE ri,
2050: BOM_BILL_OF_MTLS_INTERFACE bi
2051: where ci.bill_sequence_id = bi.bill_sequence_id
2052: and oi.operation_seq_num = ci.operation_seq_num
2053: and oi.routing_sequence_id = ri.routing_sequence_id
2054: and ri.assembly_item_id = bi.assembly_item_id

Line 2062: from bom_bill_of_mtls_interface bi2

2058: and bi.alternate_bom_designator is NULL
2059: and bi.set_id ||''= TO_CHAR(to_number(USERENV('SESSIONID'))))
2060: and ci.bill_sequence_id in
2061: ( select bi2.bill_sequence_id
2062: from bom_bill_of_mtls_interface bi2
2063: where bi2.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2064:
2065:
2066: /*

Line 2329: bom_bill_of_mtls_interface b

2325: ic.operation_seq_num
2326: from
2327: bom_inventory_comps_interface ic,
2328: bom_reference_designators r,
2329: bom_bill_of_mtls_interface b
2330: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2331: and ic.bill_sequence_id = b.bill_sequence_id
2332: and r.component_sequence_id = ic.model_comp_seq_id
2333: and nvl(r.acd_type,0) <> 3;

Line 2345: bom_bill_of_mtls_interface bi,

2341: set i.element_value =
2342: ( select /*+ ORDERED */
2343: NVL(max(v.element_value),i.element_value)
2344: from
2345: bom_bill_of_mtls_interface bi,
2346: bom_inventory_comps_interface bci,
2347: bom_inventory_components bc,
2348: bom_dependent_desc_elements be,
2349: mtl_descr_element_values v