DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_SEED_PVT dependencies on OE_ORDER_LINES_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 2282: FROM oe_order_lines_all I,

2278: H.object_type, H.object_id, I.line_id, I.unit_selling_price,
2279: decode(H.flow_status_code, 'BOOKED', H.header_id, NULL) header_id,
2280: decode(H.flow_status_code, 'BOOKED', I.ordered_quantity, 0) ordered_quantity,
2281: I.invoiced_quantity, H.currency_code
2282: FROM oe_order_lines_all I,
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

Line 2936: oe_order_lines_all I,

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
2940: AND ((source_category = 'B2B'

Line 3081: oe_order_lines_all I,

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
3085: AND ((source_category = 'B2B'

Line 3416: oe_order_lines_all I

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'
3420: AND exists (select 1 from hz_cust_account_roles roles