APPS.AHL_PRD_UTIL_PKG dependencies on BOM_RESOURCES

Line 1044: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1040: p_workorder_id IN NUMBER,
1041: p_operation_seq_num IN NUMBER) IS
1042: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1043: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1044: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1045: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1046: AND AOR.operation_resource_id = AWAS.operation_resource_id
1047: AND BOM.resource_id = AOR.resource_id
1048: AND BOM.resource_type = 2 -- Person

Line 1058: BOM_RESOURCES BOMR,

1054: CURSOR c_get_total_hours_op(p_workorder_id IN NUMBER,
1055: p_operation_seq_num IN NUMBER) IS
1056: SELECT SUM(NVL(AOR.duration, 0))
1057: FROM AHL_OPERATION_RESOURCES AOR,
1058: BOM_RESOURCES BOMR,
1059: AHL_WORKORDER_OPERATIONS AWOP
1060: WHERE AOR.RESOURCE_ID = BOMR.RESOURCE_ID
1061: AND BOMR.resource_type = 2 -- Person
1062: AND AOR.WORKORDER_OPERATION_ID = AWOP.WORKORDER_OPERATION_ID

Line 1126: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1122: p_operation_seq_num IN NUMBER,
1123: p_resource_id IN NUMBER) IS
1124: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1125: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1126: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1127: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1128: AND AOR.operation_resource_id = AWAS.operation_resource_id
1129: AND BOM.resource_id = AOR.resource_id
1130: AND BOM.resource_type = 2 -- Person

Line 1142: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1138: p_operation_seq_num IN NUMBER,
1139: p_resource_id IN NUMBER) IS
1140: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1141: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1142: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1143: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1144: AND AOR.operation_resource_id = AWAS.operation_resource_id
1145: AND BOM.resource_id = AOR.resource_id
1146: AND BOM.resource_type = 2 -- Person

Line 1207: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1203: CURSOR c_get_res_txns_emp(p_wip_entity_id IN NUMBER,
1204: p_operation_seq_num IN NUMBER,
1205: p_employee_id IN NUMBER ) IS
1206: SELECT NVL( SUM( transaction_quantity ), 0 )
1207: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1208: WHERE WT.resource_id = BRS.resource_id
1209: AND BRS.resource_type = 2 -- person.
1210: AND wt.wip_entity_id = p_wip_entity_id
1211: AND wt.operation_seq_num = p_operation_seq_num

Line 1219: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor

1215: CURSOR c_get_pend_res_txns_emp(p_wip_entity_id NUMBER,
1216: p_operation_seq_num NUMBER,
1217: p_employee_id NUMBER ) IS
1218: SELECT NVL( SUM( transaction_quantity ), 0 )
1219: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1220: WHERE wcti.wip_entity_id = wor.wip_entity_id
1221: AND wcti.operation_seq_num = wor.operation_seq_num
1222: AND wcti.resource_seq_num = wor.resource_seq_num
1223: AND wcti.organization_id = wor.organization_id

Line 1235: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1231: -- query to retrieve total hrs transacted by all employees.
1232: CURSOR c_get_res_txns_op(p_wip_entity_id IN NUMBER,
1233: p_operation_seq_num IN NUMBER) IS
1234: SELECT NVL( SUM( transaction_quantity ), 0 )
1235: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1236: WHERE WT.resource_id = BRS.resource_id
1237: AND BRS.resource_type = 2 -- person.
1238: AND WT.wip_entity_id = p_wip_entity_id
1239: AND WT.operation_seq_num = p_operation_seq_num;

Line 1247: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor

1243: p_operation_seq_num NUMBER) IS
1244: -- Here we cannot join with wcti.resource_id column
1245: -- since this col can be null.
1246: SELECT NVL( SUM( transaction_quantity ), 0 )
1247: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1248: WHERE wcti.wip_entity_id = wor.wip_entity_id
1249: AND wcti.operation_seq_num = wor.operation_seq_num
1250: AND wcti.resource_seq_num = wor.resource_seq_num
1251: AND wcti.organization_id = wor.organization_id

Line 1334: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1330: p_operation_seq_num IN NUMBER,
1331: p_resource_seq_num IN NUMBER,
1332: p_employee_id IN NUMBER ) IS
1333: SELECT NVL( SUM( transaction_quantity ), 0 )
1334: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1335: WHERE WT.resource_id = BRS.resource_id
1336: AND BRS.resource_type = 2 -- person.
1337: AND WT.transaction_type = 1 -- resource txn.
1338: AND wt.wip_entity_id = p_wip_entity_id

Line 1349: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,

1345: p_operation_seq_num NUMBER,
1346: p_resource_seq_num IN NUMBER,
1347: p_employee_id NUMBER ) IS
1348: SELECT NVL( SUM( transaction_quantity ), 0 )
1349: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1350: wip_operation_resources wor
1351: WHERE wcti.wip_entity_id = wor.wip_entity_id
1352: AND wcti.operation_seq_num = wor.operation_seq_num
1353: AND wcti.resource_seq_num = wor.resource_seq_num

Line 1369: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1365: CURSOR c_get_res_txns_res(p_wip_entity_id IN NUMBER,
1366: p_operation_seq_num IN NUMBER,
1367: p_resource_seq_num IN NUMBER) IS
1368: SELECT NVL( SUM( transaction_quantity ), 0 )
1369: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1370: WHERE WT.resource_id = BRS.resource_id
1371: AND BRS.resource_type = 2 -- person.
1372: AND WT.transaction_type = 1 -- resource txn.
1373: AND wt.wip_entity_id = p_wip_entity_id

Line 1384: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,

1380: CURSOR c_get_pend_res_txns_res(p_wip_entity_id IN NUMBER,
1381: p_operation_seq_num IN NUMBER,
1382: p_resource_seq_num IN NUMBER) IS
1383: SELECT NVL( SUM( transaction_quantity ), 0 )
1384: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1385: wip_operation_resources wor
1386: WHERE wcti.wip_entity_id = wor.wip_entity_id
1387: AND wcti.operation_seq_num = wor.operation_seq_num
1388: AND wcti.resource_seq_num = wor.resource_seq_num