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