DBA Data[Home] [Help]

APPS.ONT_IMPLICITCUSTACCEPT_PVT dependencies on OE_ORDER_LINES_ALL

Line 27: g_query_from_clause VARCHAR2(1000) := ' FROM oe_order_lines_all ';

23: ', accepted_quantity '||
24: ', sold_to_org_id '||
25: ', revrec_expiration_days';
26:
27: g_query_from_clause VARCHAR2(1000) := ' FROM oe_order_lines_all ';
28: g_query_where_clause VARCHAR2(3000) := ' WHERE flow_status_code = ''PRE-BILLING_ACCEPTANCE''';
29: g_customer_acceptance_enabled BOOLEAN;
30: g_fulfillment_action VARCHAR2(40);
31: g_return_status VARCHAR2(1);

Line 276: FROM oe_order_lines_all

272:
273: BEGIN
274: SELECT fulfillment_date
275: INTO l_fulfillment_date
276: FROM oe_order_lines_all
277: WHERE line_id = l_line_id;
278: EXCEPTION
279:
280: WHEN OTHERS THEN

Line 382: l_query_from_clause := ' FROM oe_order_lines_all oel, ar_deferral_reasons arc ';

378: END IF;
379:
380: /* myerrams, Bug: 5531056. Modified the l_cust_query to restrict records with Acceptance Expire Event as Ship Confirm Date and REVREC_EVENT_CODE as Invoicing (Pre-Billing Acceptance) */
381: l_query_where_clause := ' WHERE oel.contingency_id = arc.contingency_id AND oel.flow_status_code = :1 AND oel.org_id = :2 and oel.open_flag = :3 AND arc.expiration_event_code = :4 AND oel.REVREC_EVENT_CODE = :5 ';
382: l_query_from_clause := ' FROM oe_order_lines_all oel, ar_deferral_reasons arc ';
383: l_cust_query := l_cust_query || l_query_from_clause || l_query_where_clause;
384: IF l_debug_level > 0 THEN
385: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);
386: END IF;

Line 427: FROM oe_order_lines_all

423: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);
424: END IF;
425: SELECT count(*)
426: INTO l_count
427: FROM oe_order_lines_all
428: WHERE header_id = l_header_id
429: AND top_model_line_id = l_line_id
430: AND flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE') --myerrams, Bug: 5290313
431: AND nvl(open_flag, 'Y') = 'Y';

Line 436: FROM oe_order_lines_all

432: /* If all the Child/Included lines are either Pending Pre-Billing_Acceptance or Closed */
433: IF l_count = 0 THEN
434: SELECT max(actual_shipment_date)
435: INTO l_max_actual_shipment_date
436: FROM oe_order_lines_all
437: WHERE header_id = l_header_id
438: AND top_model_line_id = l_line_id;
439:
440: IF l_max_actual_shipment_date IS NULL THEN

Line 475: FROM oe_order_lines_all

471:
472: BEGIN
473: SELECT fulfillment_date
474: INTO l_fulfillment_date
475: FROM oe_order_lines_all
476: WHERE line_id = l_line_id;
477: EXCEPTION
478:
479: WHEN OTHERS THEN

Line 645: FROM oe_order_lines_all

641: INTO l_line_id
642: , l_contingency_id
643: , l_revrec_event_code
644: , l_accepted_quantity
645: FROM oe_order_lines_all
646: WHERE line_id = l_product_line_id;
647:
648: IF l_contingency_id IS NOT NULL
649: AND l_accepted_quantity IS NOT NULL