eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_RTG_OI_UTIL dependencies on BOM_OP_RESOURCES_INTERFACE

Line 725: INSERT into bom_op_resources_interface (

721:
722: stmt_num := 11;
723:
724: /* INSERTS ONLY - Load rows from operation interface into resource interface*/
725: INSERT into bom_op_resources_interface (
726: RESOURCE_ID,
727: RESOURCE_CODE,
728: ORGANIZATION_ID,
729: ORGANIZATION_CODE,

Line 788: INSERT into bom_op_resources_interface (

784: AND (RESOURCE_CODE1 is not null
785: OR
786: RESOURCE_ID1 is not null);
787:
788: INSERT into bom_op_resources_interface (
789: RESOURCE_ID,
790: RESOURCE_CODE,
791: ORGANIZATION_ID,
792: ORGANIZATION_CODE,

Line 851: INSERT into bom_op_resources_interface (

847: AND (RESOURCE_CODE2 is not null
848: OR
849: RESOURCE_ID2 is not null);
850:
851: INSERT into bom_op_resources_interface (
852: RESOURCE_ID,
853: RESOURCE_CODE,
854: ORGANIZATION_ID,
855: ORGANIZATION_CODE,

Line 1008: BOM_OP_RESOURCES_INTERFACE

1004: in the interface table
1005: REQUIRES
1006:
1007: MODIFIES
1008: BOM_OP_RESOURCES_INTERFACE
1009: MTL_INTERFACE_ERRORS
1010: RETURNS
1011: 0 if successful
1012: SQLCODE if unsuccessful

Line 1038: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1034: BEGIN
1035: stmt_num := 1;
1036: /* Resolve the operation_sequence_id for all the records */
1037:
1038: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1039: SET(routing_sequence_id, effectivity_date, operation_seq_num)
1040: = (SELECT routing_sequence_id, effectivity_date, operation_seq_num
1041: FROM BOM_OPERATION_SEQUENCES BOS1
1042: WHERE BOS1.operation_sequence_id = BORI.operation_sequence_id )

Line 1059: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1055:
1056: stmt_num := 2;
1057: /* Resolve the routing sequence ids */
1058:
1059: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1060: SET(assembly_item_id, organization_id, alternate_routing_designator)
1061: = (SELECT assembly_item_id, organization_id, alternate_routing_designator
1062: FROM BOM_OPERATIONAL_ROUTINGS BOR1
1063: WHERE BOR1.routing_sequence_id = BORI.routing_sequence_id)

Line 1081: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1077: stmt_num := 3;
1078: /* Update Organization Code using Organization_id
1079: this also needed if Organization_id is given and code is not given*/
1080:
1081: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1082: SET organization_code = (SELECT organization_code
1083: FROM MTL_PARAMETERS mp1
1084: WHERE mp1.organization_id = BORI.organization_id)
1085: WHERE process_flag = 1

Line 1103: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1099: stmt_num := 4;
1100: /* Update Organization_ids if organization_code is given org id is null.
1101: Orgnaization_id information is needed in the next steps */
1102:
1103: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1104: SET organization_id = (SELECT organization_id
1105: FROM MTL_PARAMETERS mp1
1106: WHERE mp1.organization_code = BORI.organization_code)
1107: WHERE process_flag = 1

Line 1122: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1118:
1119: stmt_num := 5;
1120: /* Update Assembly Item name */
1121:
1122: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1123: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1124: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1125: WHERE mvl1.inventory_item_id = BORI.assembly_item_id
1126: and mvl1.organization_id = BORI.organization_id)

Line 1145: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1141:
1142: stmt_num := 6;
1143: /* Update resource code */
1144:
1145: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1146: SET resource_code = (SELECT resource_code
1147: FROM BOM_RESOURCES br
1148: WHERE br.resource_id = BORI.resource_id
1149: and br.organization_id = BORI.organization_id)

Line 1168: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1164:
1165: stmt_num := 7;
1166: /* Assign transaction ids */
1167:
1168: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1169: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
1170: WHERE transaction_id is null
1171: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)
1172: AND process_flag = 1

Line 1182: UPDATE BOM_OP_RESOURCES_INTERFACE BORI

1178: AND (all_org = 1
1179: OR
1180: (all_org = 2 AND organization_id = org_id));
1181:
1182: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1183: SET transaction_type = upper(transaction_type)
1184: WHERE upper(transaction_type) in (G_Create, G_Update, G_Delete)
1185: AND process_flag = 1
1186: AND

Line 1231: 'BOM_OP_RESOURCES_INTERFACE',

1227: BORI.transaction_id,
1228: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1229: Null,
1230: null,
1231: 'BOM_OP_RESOURCES_INTERFACE',
1232: decode ( BORI.Organization_code, null, msg_name1,msg_name2),
1233: decode ( BORI.Organization_code, null, msg_text1,msg_text2),
1234: NVL(LAST_UPDATE_DATE, SYSDATE),
1235: NVL(LAST_UPDATED_BY, user_id),

Line 1243: from BOM_OP_RESOURCES_INTERFACE BORI

1239: NVL(REQUEST_ID, req_id),
1240: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1241: NVL(PROGRAM_ID, prog_id),
1242: NVL(PROGRAM_UPDATE_DATE, sysdate)
1243: from BOM_OP_RESOURCES_INTERFACE BORI
1244: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1245: and transaction_id is not null
1246: and process_flag =1
1247: and

Line 1254: Update BOM_OP_RESOURCES_INTERFACE

1250: OR ( p_batch_id = batch_id )
1251: )
1252: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id)) ;
1253:
1254: Update BOM_OP_RESOURCES_INTERFACE
1255: set process_flag = 3
1256: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1257: and transaction_id is not null
1258: and process_flag =1