DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_INVENTORY_COMPONENTS_S

Line 1140: select bom_inventory_components_s.nextval

1136: WriteToLog('Entering Update_Bom_Rtg_Loop', 2);
1137:
1138: xBillId := 0;
1139: lStmtNum := 10;
1140: select bom_inventory_components_s.nextval
1141: into lConfigBillId
1142: from dual;
1143:
1144: WriteToLog('Creating Bill:: ' || lConfigBillId, 2);

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

1340: NULL, -- low_quantity */
1341: NULL, -- high_quantity */
1342: NULL, -- acd_type */
1343: NULL, --old_component_sequence_id */
1344: bom_inventory_components_s.nextval, -- component sequence id */
1345: lConfigBillId, -- bill sequence id */
1346: NULL, -- request_id */
1347: NULL, -- program_application_id */
1348: NULL, -- program_id */

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

1586: NULL, -- low_quantity
1587: NULL, -- high_quantity
1588: NULL, -- acd_type
1589: NULL, -- old_component_sequence_id
1590: bom_inventory_components_s.nextval, -- component sequence id
1591: lConfigBillId, -- bill sequence id
1592: NULL, -- request_id
1593: NULL, -- program_application_id
1594: NULL, -- program_id

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

2233: NULL, -- low_quantity
2234: NULL, -- high_quantity
2235: NULL, -- acd_type
2236: NULL, -- old_component_sequence_id
2237: bom_inventory_components_s.nextval, -- component sequence id
2238: lConfigBillId, -- bill sequence id
2239: NULL, -- request_id
2240: NULL, -- program_application_id
2241: NULL, -- program_id

Line 4070: bom_inventory_components_s.nextval,

4066: low_quantity,
4067: high_quantity,
4068: acd_type,
4069: old_component_sequence_id,
4070: bom_inventory_components_s.nextval,
4071: request_id,
4072: program_application_id,
4073: program_id,
4074: program_update_date,

Line 5903: bom_inventory_components_s.nextval,

5899: 2,
5900: ic1.required_for_revenue,
5901: ic1.include_on_ship_docs,
5902: ic1.include_on_bill_docs,
5903: bom_inventory_components_s.nextval,
5904: pConfigBillId,
5905: ic1.wip_supply_type,
5906: 2,
5907: decode(bcol1.config_item_id, NULL, (-1)*ic1.component_sequence_id, ic1.component_sequence_id),

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

6103: 2, -- required_to_ship = NO
6104: bic.required_for_revenue,
6105: bic.include_on_ship_docs,
6106: bic.include_on_bill_docs,
6107: bom_inventory_components_s.nextval, -- component sequence id
6108: pConfigBillId, -- bill sequence id
6109: bic.wip_supply_type,
6110: 2, -- pick_components = NO
6111: (-1)*bic.component_sequence_id, -- model comp seq for later use

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

6287: 2, -- required_to_ship = NO
6288: r2.required_for_revenue,
6289: r2.include_on_ship_docs,
6290: r2.include_on_bill_docs,
6291: bom_inventory_components_s.nextval, -- component sequence id
6292: pConfigBillId, -- bill sequence id
6293: r2.wip_supply_type,
6294: 2, -- pick_components = NO
6295: (-1)*r2.component_sequence_id, -- model comp seq for later use