DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on BOM_INVENTORY_COMPONENTS_S

Line 420: select bom_inventory_components_s.nextval

416: oe_debug_pub.add('create_bom_ml: ' || 'Setting Bill ' || lConfigBillId || ' for org ' || pOrgId
417: || ' for line id ' || pLineId , 1);
418: else
419:
420: select bom_inventory_components_s.nextval
421: into lConfigBillId
422: from dual;
423:
424: end if ;

Line 791: bom_inventory_components_s.nextval, -- component sequence id */

787: NULL, -- low_quantity */
788: NULL, -- high_quantity */
789: NULL, -- acd_type */
790: NULL, --old_component_sequence_id */
791: bom_inventory_components_s.nextval, -- component sequence id */
792: lConfigBillId, -- bill sequence id */
793: NULL, -- request_id */
794: NULL, -- program_application_id */
795: NULL, -- program_id */

Line 1066: bom_inventory_components_s.nextval, -- component sequence id

1062: NULL, -- low_quantity
1063: NULL, -- high_quantity
1064: NULL, -- acd_type
1065: NULL, -- old_component_sequence_id
1066: bom_inventory_components_s.nextval, -- component sequence id
1067: lConfigBillId, -- bill sequence id
1068: NULL, -- request_id
1069: NULL, -- program_application_id
1070: NULL, -- program_id

Line 2047: bom_inventory_components_s.nextval, -- component sequence id

2043: NULL, -- low_quantity
2044: NULL, -- high_quantity
2045: NULL, -- acd_type
2046: NULL, -- old_component_sequence_id
2047: bom_inventory_components_s.nextval, -- component sequence id
2048: lConfigBillId, -- bill sequence id
2049: NULL, -- request_id
2050: NULL, -- program_application_id
2051: NULL, -- program_id

Line 2713: bom_inventory_components_s.nextval,

2709: low_quantity,
2710: high_quantity,
2711: acd_type,
2712: old_component_sequence_id,
2713: bom_inventory_components_s.nextval,
2714: request_id,
2715: program_application_id,
2716: program_id,
2717: program_update_date,

Line 4316: bom_inventory_components_s.nextval, -- component sequence id

4312: 2, -- required_to_ship = NO
4313: ic1.required_for_revenue,
4314: ic1.include_on_ship_docs,
4315: ic1.include_on_bill_docs,
4316: bom_inventory_components_s.nextval, -- component sequence id
4317: pConfigBillId, -- bill sequence id
4318: ic1.wip_supply_type,
4319: 2, -- pick_components = NO
4320: decode(bcol1.config_item_id, NULL, (-1)*ic1.component_sequence_id, ic1.component_sequence_id), -- saved model comp seq for later use. If config item, then save model comp seq id as positive, otherwise negative.

Line 4561: bom_inventory_components_s.nextval, -- component sequence id

4557: 2, -- required_to_ship = NO
4558: bic.required_for_revenue,
4559: bic.include_on_ship_docs,
4560: bic.include_on_bill_docs,
4561: bom_inventory_components_s.nextval, -- component sequence id
4562: pConfigBillId, -- bill sequence id
4563: bic.wip_supply_type,
4564: 2, -- pick_components = NO
4565: (-1)*bic.component_sequence_id, -- model comp seq for later use

Line 4888: bom_inventory_components_s.nextval, -- component sequence id

4884: 2, -- required_to_ship = NO
4885: r2.required_for_revenue,
4886: r2.include_on_ship_docs,
4887: r2.include_on_bill_docs,
4888: bom_inventory_components_s.nextval, -- component sequence id
4889: pConfigBillId, -- bill sequence id
4890: r2.wip_supply_type,
4891: 2, -- pick_components = NO
4892: (-1)*r2.component_sequence_id, -- model comp seq for later use