APPS.OE_BLANKET_UTIL dependencies on DUAL

Line 67: SELECT p_sold_to_org_id FROM DUAL

63: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
64: AND SITE.STATUS = 'A'
65: AND ACCT_SITE.STATUS ='A' AND --bug 2752321
66: ACCT_SITE.CUST_ACCOUNT_ID in (
67: SELECT p_sold_to_org_id FROM DUAL
68: UNION
69: SELECT CUST_ACCOUNT_ID FROM
70: HZ_CUST_ACCT_RELATE_ALL h WHERE
71: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 146: SELECT p_sold_to_org_id FROM DUAL

142: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
143: AND SITE.STATUS = 'A'
144: AND ACCT_SITE.STATUS ='A' AND
145: ACCT_SITE.CUST_ACCOUNT_ID in (
146: SELECT p_sold_to_org_id FROM DUAL
147: UNION
148: SELECT CUST_ACCOUNT_ID FROM
149: HZ_CUST_ACCT_RELATE_ALL h WHERE
150: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 234: SELECT p_sold_to_org_id FROM DUAL

230: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
231: AND SITE.STATUS = 'A'
232: AND ACCT_SITE.STATUS ='A' AND
233: ACCT_SITE.CUST_ACCOUNT_ID in (
234: SELECT p_sold_to_org_id FROM DUAL
235: UNION
236: SELECT CUST_ACCOUNT_ID FROM
237: HZ_CUST_ACCT_RELATE_ALL h WHERE
238: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id

Line 6551: FROM DUAL;

6547: -- Default Blanket Header ID
6548: IF p_x_header_rec.header_id IS NULL THEN
6549: SELECT OE_ORDER_HEADERS_S.NEXTVAL
6550: INTO p_x_header_rec.header_id
6551: FROM DUAL;
6552: END IF;
6553:
6554: -- Default Start Date Active
6555: IF p_x_header_rec.start_Date_active IS NULL THEN

Line 6725: FROM DUAL;

6721: -- Get Blanket Line
6722: IF p_x_line_rec.line_id IS NULL THEN
6723: SELECT OE_ORDER_LINES_S.NEXTVAL
6724: INTO p_x_line_rec.line_id
6725: FROM DUAL;
6726: END IF;
6727:
6728: -- Get Blanket Line Number
6729: IF p_x_line_rec.line_number IS NULL THEN

Line 7680: FROM DUAL;

7676:
7677: -- Pre-default header_id for proper message display
7678: SELECT OE_ORDER_HEADERS_S.NEXTVAL
7679: INTO l_header_rec.header_id
7680: FROM DUAL;
7681:
7682: l_header_rec.order_number := NULL;
7683: l_header_rec.version_number := 0;
7684: l_header_rec.operation := oe_globals.g_opr_create;

Line 7732: FROM DUAL;

7728:
7729: -- Pre-default header_id for proper message display
7730: SELECT OE_ORDER_LINES_S.NEXTVAL
7731: INTO l_line_tbl(l_count).line_id
7732: FROM DUAL;
7733:
7734: l_line_tbl(l_count).operation := oe_globals.g_opr_create;
7735: l_line_tbl(l_count).order_number := NULL;
7736: l_line_tbl(l_count).line_number := NULL;