DBA Data[Home] [Help]

APPS.OTA_WF dependencies on OE_ORDER_LINES_ALL

Line 640: FROM OE_ORDER_LINES_ALL

636: l_course_end_date OTA_EVENTS.course_end_date%type;
637:
638: CURSOR C_ORDER IS
639: SELECT HEADER_ID,ORG_ID
640: FROM OE_ORDER_LINES_ALL
641: WHERE LINE_ID = l_line_id;
642:
643: BEGIN
644: hr_utility.set_location('Entering:'||l_proc, 5);

Line 948: oe_order_lines_all ol,

944: ol.order_quantity_uom ,
945: oh.order_number,
946: ol.line_number
947: FROM
948: oe_order_lines_all ol,
949: oe_order_headers_all oh
950: WHERE
951: oh.header_id = ol.header_id and
952: ol.line_id = l_line_id;

Line 1457: oe_order_lines_all

1453: IS
1454: SELECT
1455: invoicing_rule_id
1456: FROM
1457: oe_order_lines_all
1458: WHERE
1459: line_id = to_number(itemkey);
1460:
1461: l_proc varchar2(72) := g_package||'check_invoice_rule';

Line 1462: l_rule_id oe_order_lines_all.invoicing_rule_id%type;

1458: WHERE
1459: line_id = to_number(itemkey);
1460:
1461: l_proc varchar2(72) := g_package||'check_invoice_rule';
1462: l_rule_id oe_order_lines_all.invoicing_rule_id%type;
1463:
1464: BEGIN
1465: hr_utility.set_location('Entering:'||l_proc, 5);
1466: IF (funcmode = 'RUN') THEN

Line 1710: oe_order_lines_all ol,

1706: ol.order_quantity_uom ,
1707: oh.order_number,
1708: ol.line_number
1709: FROM
1710: oe_order_lines_all ol,
1711: oe_order_headers_all oh
1712: WHERE
1713: oh.header_id = ol.header_id and
1714: ol.line_id = l_line_id;