DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on BOM_INVENTORY_COMPONENTS_S

Line 418: select bom_inventory_components_s.nextval

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

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

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

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

1037: NULL, -- low_quantity
1038: NULL, -- high_quantity
1039: NULL, -- acd_type
1040: NULL, -- old_component_sequence_id
1041: bom_inventory_components_s.nextval, -- component sequence id
1042: lConfigBillId, -- bill sequence id
1043: NULL, -- request_id
1044: NULL, -- program_application_id
1045: NULL, -- program_id

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

2017: NULL, -- low_quantity
2018: NULL, -- high_quantity
2019: NULL, -- acd_type
2020: NULL, -- old_component_sequence_id
2021: bom_inventory_components_s.nextval, -- component sequence id
2022: lConfigBillId, -- bill sequence id
2023: NULL, -- request_id
2024: NULL, -- program_application_id
2025: NULL, -- program_id

Line 2653: bom_inventory_components_s.nextval,

2649: low_quantity,
2650: high_quantity,
2651: acd_type,
2652: old_component_sequence_id,
2653: bom_inventory_components_s.nextval,
2654: request_id,
2655: program_application_id,
2656: program_id,
2657: program_update_date,

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

4129: 2, -- required_to_ship = NO
4130: ic1.required_for_revenue,
4131: ic1.include_on_ship_docs,
4132: ic1.include_on_bill_docs,
4133: bom_inventory_components_s.nextval, -- component sequence id
4134: pConfigBillId, -- bill sequence id
4135: ic1.wip_supply_type,
4136: 2, -- pick_components = NO
4137: 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 4373: bom_inventory_components_s.nextval, -- component sequence id

4369: 2, -- required_to_ship = NO
4370: bic.required_for_revenue,
4371: bic.include_on_ship_docs,
4372: bic.include_on_bill_docs,
4373: bom_inventory_components_s.nextval, -- component sequence id
4374: pConfigBillId, -- bill sequence id
4375: bic.wip_supply_type,
4376: 2, -- pick_components = NO
4377: (-1)*bic.component_sequence_id, -- model comp seq for later use

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

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