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.

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 727: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL I,

723: DECODE(H.FLOW_STATUS_CODE, G_BOOKED, H.HEADER_ID, NULL) HEADER_ID,
724: DECODE(H.FLOW_STATUS_CODE, G_BOOKED, I.ORDERED_QUANTITY, 0) ORDERED_QUANTITY,
725: I.INVOICED_QUANTITY,
726: NVL(H.TRANSACTIONAL_CURR_CODE,G_FUNC_CURRENCY) CURRENCY_CODE
727: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL I,
728: (SELECT DISTINCT ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID, SOURCE_CODE_ID
729: FROM AMS_SOURCE_CODES C, AMS_ACT_METRICS_ALL A, AMS_METRICS_ALL_B B
730: WHERE A.ARC_ACT_METRIC_USED_BY = C.ARC_SOURCE_CODE_FOR
731: AND A.ACT_METRIC_USED_BY_ID = C.SOURCE_CODE_FOR_ID

Line 1289: FROM oe_order_headers_all H, oe_order_lines_all I,

1285: decode(H.flow_status_code, G_BOOKED, H.header_id, NULL) header_id,
1286: decode(H.flow_status_code, G_BOOKED, I.ordered_quantity, 0) ordered_quantity,
1287: I.invoiced_quantity,
1288: nvl(H.transactional_curr_code,G_FUNC_CURRENCY) currency_code
1289: FROM oe_order_headers_all H, oe_order_lines_all I,
1290: ams_source_codes C
1291: WHERE H.header_id = I.header_id(+)
1292: AND H.booked_flag = G_BOOKED_FLAG
1293: AND H.booked_date IS NOT NULL

Line 2287: FROM oe_order_headers_all H, hz_cust_accounts A

2283: (SELECT H.header_id, H.flow_status_code, H.org_id,
2284: H.transactional_curr_code currency_code,
2285: list_parties.object_type,
2286: list_parties.object_id
2287: FROM oe_order_headers_all H, hz_cust_accounts A
2288: , (
2289: -- SELECT DISTINCT LIST OF B2C AND B2B PARTIES
2290: SELECT distinct actlist_source.source_code_for_id,
2291: actlist_source.arc_source_code_for,

Line 2935: oe_order_headers_all H,

2931: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
2932: AND REL.DIRECTIONAL_FLAG(+) = 'F'
2933: ) csch_parties,
2934: hz_cust_accounts account,
2935: oe_order_headers_all H,
2936: oe_order_lines_all I,
2937: ams_act_products aprod
2938: where csch_parties.primary_party_id = account.party_id
2939: AND H.sold_to_org_id = account.cust_account_id

Line 3080: oe_order_headers_all H,

3076: AND REL.PARTY_ID(+) = ENTRY.LIST_ENTRY_SOURCE_SYSTEM_ID
3077: AND REL.DIRECTIONAL_FLAG(+) = 'F'
3078: ) csch_parties,
3079: hz_cust_accounts account,
3080: oe_order_headers_all H,
3081: oe_order_lines_all I,
3082: ams_act_products aprod
3083: where csch_parties.primary_party_id = account.party_id
3084: AND H.sold_to_org_id = account.cust_account_id

Line 3415: oe_order_headers_all H,

3411: primary_party_id, contact_rel_party_id
3412: from AMS_INFMET_ORDER_GT csch_parties,
3413: ams_act_products aprod,
3414: hz_cust_accounts account,
3415: oe_order_headers_all H,
3416: oe_order_lines_all I
3417: where csch_parties.primary_party_id = account.party_id
3418: AND H.sold_to_org_id = account.cust_account_id
3419: AND ((source_category = 'B2B'