DBA Data[Home] [Help]

APPS.CSTPPWRO dependencies on BOM_RESOURCES

Line 1032: bom_resources br /* Bug 4641635; Include resources which are to be costed */

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
1035: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1036: AND (TRUNC(p_end_date) + 0.99999)

Line 1061: bom_resources br /* Bug 4641635; Include resources which are to be costed */

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)
1065: AND wt.transaction_type = 3 -- OSP