92:
93: /* Set the unique transaction_id for each row */
94: Update CST_ITEM_CST_DTLS_INTERFACE
95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
101: program_update_date = sysdate,
102: process_flag = 2
103: where error_flag is null
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,
100: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
101: program_update_date = sysdate,
102: process_flag = 2
103: where error_flag is null
104: AND process_flag = 1
893: Select Inventory_item_id,
894: organization_id,
895: cost_type_id,
896: sysdate,
897: FND_GLOBAL.USER_ID,
898: sysdate,
899: FND_GLOBAL.USER_ID,
900: inventory_asset_flag,
901: lot_size,
895: cost_type_id,
896: sysdate,
897: FND_GLOBAL.USER_ID,
898: sysdate,
899: FND_GLOBAL.USER_ID,
900: inventory_asset_flag,
901: lot_size,
902: based_on_rollup_flag,
903: shrinkage_rate,
921: SUM(item_cost),
922: SUM(item_cost),
923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct
922: SUM(item_cost),
923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct
930: WHERE error_flag is null
923: (SUM(ct.item_cost) - SUM(decode(ct.cost_element_id,2,ct.item_cost,0))),
924: SUM(decode(ct.cost_element_id,2,ct.item_cost,null)),
925: FND_GLOBAL.CONC_REQUEST_ID,
926: FND_GLOBAL.PROG_APPL_ID,
927: FND_GLOBAL.CONC_PROGRAM_ID,
928: sysdate
929: FROM CST_ITEM_CST_DTLS_INTERFACE ct
930: WHERE error_flag is null
931: AND group_id = SEQ_NEXTVAL
1030: SELECT inventory_item_id,
1031: organization_id,
1032: cost_type_id,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.USER_ID,
1037: level_type,
1038: activity_id,
1032: cost_type_id,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.USER_ID,
1037: level_type,
1038: activity_id,
1039: resource_id,
1040: resource_rate,
1047: item_cost,
1048: cost_element_id,
1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,
1048: cost_element_id,
1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,
1056: attribute1,
1049: rollup_source_type,
1050: activity_context,
1051: FND_GLOBAL.CONC_REQUEST_ID,
1052: FND_GLOBAL.PROG_APPL_ID,
1053: FND_GLOBAL.CONC_PROGRAM_ID,
1054: sysdate,
1055: attribute_category,
1056: attribute1,
1057: attribute2,