[Home] [Help]
578: l_stmt_num := 17;
579:
580: SELECT NVL(MAX(wt.transaction_id),-99)
581: INTO l_wt
582: FROM wip_transactions wt
583: WHERE wt.wip_entity_id = p_entity_id
584: AND wt.line_id = c_rec.line_id
585: AND wt.move_transaction_id = c_rec.move_txn_id;
586:
999: WHERE ccga.cost_group_id = p_cost_group_id
1000: AND we.organization_id = ccga.organization_id
1001: AND EXISTS
1002: ( SELECT 'X'
1003: FROM wip_transactions wt
1004: WHERE wt.wip_entity_id = we.wip_entity_id
1005: AND wt.transaction_type IN (1,2,3,17)
1006: -- Direct Item txns should be picked too.
1007: AND wt.transaction_date BETWEEN
1010: AND ccga.organization_id = wt.organization_id
1011: );
1012:
1013: -- Cursor to process resource/OSP transaction for a given wip_entity/cost_type
1014: -- It will get all resource/osp type records from WIP_TRANSACTIONS where the
1015: -- resource/osp has a non zero rate defined for the PAC_RATES cost type.
1016:
1017: CURSOR c_res_txn ( p_entity_id NUMBER) IS
1018: SELECT wt.transaction_id txn_id,
1027: wt.transaction_type wip_txn_type,
1028: wt.primary_quantity applied_units,
1029: wt.primary_quantity*nvl(crc.resource_rate,0) applied_value,
1030: wt.rcv_transaction_id -- Added for 4735668
1031: FROM wip_transactions wt,
1032: cst_resource_costs crc,
1033: bom_resources br /* Bug 4641635; Include resources which are to be costed */
1034:
1035: WHERE wt.wip_entity_id = p_entity_id
1057: wt.transaction_type wip_txn_type,
1058: wt.primary_quantity applied_units,
1059: 0 applied_value,
1060: wt.rcv_transaction_id -- Added for 4735668
1061: FROM wip_transactions wt,
1062: bom_resources br /* Bug 4641635; Include resources which are to be costed */
1063: WHERE wt.wip_entity_id = p_entity_id
1064: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1065: AND (TRUNC(p_end_date) + 0.99999)
1081: wt.transaction_type wip_txn_type,
1082: nvl(wt.primary_quantity, rt.amount) applied_units, /* Bug 4180323*/
1083: 0 applied_value,
1084: wt.rcv_transaction_id -- Added for 4735668
1085: FROM wip_transactions wt,
1086: rcv_transactions rt
1087: WHERE wt.wip_entity_id = p_entity_id
1088: AND rt.transaction_id = wt.rcv_transaction_id
1089: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1119: AND cro.overhead_id = cdo.overhead_id
1120: AND cro.organization_id = cdo.organization_id;
1121:
1122: -- Cursor to process move based ovhd transaction for a given entity/cost_type
1123: -- It will get all overhead type records from WIP_TRANSACTIONS where the
1124: -- overhead has a non zero rate defined for the PAC_RATES cost type.
1125:
1126: CURSOR c_mbo_txn( p_entity_id NUMBER) IS
1127: SELECT wt.transaction_id txn_id,
1134: cdo.rate_or_amount actual_cost,
1135: wt.basis_type basis_type,
1136: wt.primary_quantity*cdo.rate_or_amount applied_value
1137: FROM
1138: wip_transactions wt,
1139: wip_transaction_accounts wta,
1140: cst_department_overheads cdo
1141: WHERE wt.wip_entity_id = p_entity_id
1142: AND wt.transaction_date BETWEEN TRUNC(p_start_date)