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.

[Home] [Help]

APPS.CSTPPWRO dependencies on BOM_RESOURCES

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

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

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

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