DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_INVENTORY_COMPONENTS_S

Line 1199: select bom_inventory_components_s.nextval

1195: WriteToLog('Entering Update_Bom_Rtg_Loop', 2);
1196:
1197: xBillId := 0;
1198: lStmtNum := 10;
1199: select bom_inventory_components_s.nextval
1200: into lConfigBillId
1201: from dual;
1202:
1203: WriteToLog('Creating Bill:: ' || lConfigBillId, 2);

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

1399: NULL, -- low_quantity */
1400: NULL, -- high_quantity */
1401: NULL, -- acd_type */
1402: NULL, --old_component_sequence_id */
1403: bom_inventory_components_s.nextval, -- component sequence id */
1404: lConfigBillId, -- bill sequence id */
1405: NULL, -- request_id */
1406: NULL, -- program_application_id */
1407: NULL, -- program_id */

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

1645: NULL, -- low_quantity
1646: NULL, -- high_quantity
1647: NULL, -- acd_type
1648: NULL, -- old_component_sequence_id
1649: bom_inventory_components_s.nextval, -- component sequence id
1650: lConfigBillId, -- bill sequence id
1651: NULL, -- request_id
1652: NULL, -- program_application_id
1653: NULL, -- program_id

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

2322: NULL, -- low_quantity
2323: NULL, -- high_quantity
2324: NULL, -- acd_type
2325: NULL, -- old_component_sequence_id
2326: bom_inventory_components_s.nextval, -- component sequence id
2327: lConfigBillId, -- bill sequence id
2328: NULL, -- request_id
2329: NULL, -- program_application_id
2330: NULL, -- program_id

Line 4237: bom_inventory_components_s.nextval,

4233: low_quantity,
4234: high_quantity,
4235: acd_type,
4236: old_component_sequence_id,
4237: bom_inventory_components_s.nextval,
4238: request_id,
4239: program_application_id,
4240: program_id,
4241: program_update_date,

Line 6112: bom_inventory_components_s.nextval,

6108: 2,
6109: ic1.required_for_revenue,
6110: ic1.include_on_ship_docs,
6111: ic1.include_on_bill_docs,
6112: bom_inventory_components_s.nextval,
6113: pConfigBillId,
6114: ic1.wip_supply_type,
6115: 2,
6116: decode(bcol1.config_item_id, NULL, (-1)*ic1.component_sequence_id, ic1.component_sequence_id),

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

6312: 2, -- required_to_ship = NO
6313: bic.required_for_revenue,
6314: bic.include_on_ship_docs,
6315: bic.include_on_bill_docs,
6316: bom_inventory_components_s.nextval, -- component sequence id
6317: pConfigBillId, -- bill sequence id
6318: bic.wip_supply_type,
6319: 2, -- pick_components = NO
6320: (-1)*bic.component_sequence_id, -- model comp seq for later use

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

6499: 2, -- required_to_ship = NO
6500: r2.required_for_revenue,
6501: r2.include_on_ship_docs,
6502: r2.include_on_bill_docs,
6503: bom_inventory_components_s.nextval, -- component sequence id
6504: pConfigBillId, -- bill sequence id
6505: r2.wip_supply_type,
6506: 2, -- pick_components = NO
6507: (-1)*r2.component_sequence_id, -- model comp seq for later use