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.INV_TRANSACTION_FLOW_PVT dependencies on DUAL

Line 90: SELECT 1 INTO l_count FROM DUAL

86: IF p_qualifier_code IS NOT NULL THEN
87: IF p_qualifier_value_id IS NOT NULL THEN
88: IF p_qualifier_code=1 THEN -- Item Categories
89:
90: SELECT 1 INTO l_count FROM DUAL
91: WHERE P_QUALIFIER_VALUE_ID IN(
92: SELECT mcv.category_id
93: FROM
94: mtl_categories_v mcv,

Line 199: SELECT 1 INTO l_count FROM DUAL

195: BEGIN
196: -- check duplicate
197: BEGIN
198:
199: SELECT 1 INTO l_count FROM DUAL
200: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
201: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
202: AND START_ORG_ID=P_START_ORG_ID
203: AND END_ORG_ID=P_END_ORG_ID

Line 257: SELECT 1 INTO l_count FROM DUAL

253: --flow's start and end date with same attributes
254: --overlap check
255: BEGIN
256: -- check if a transaction flow with start date < p_start_date
257: SELECT 1 INTO l_count FROM DUAL
258: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
259: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
260: AND START_ORG_ID=P_START_ORG_ID
261: AND END_ORG_ID=P_END_ORG_ID

Line 284: SELECT 1 INTO l_count FROM DUAL

280: --
281: BEGIN
282: --check if a transaction flow with null end date and
283: --start date < p_start_date exists
284: SELECT 1 INTO l_count FROM DUAL
285: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
286: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
287: AND START_ORG_ID=P_START_ORG_ID
288: AND END_ORG_ID=P_END_ORG_ID

Line 311: SELECT 1 INTO l_count FROM DUAL

307: END IF;
308: BEGIN
309: -- check if a transaction flow with not null end date
310: --and start date < p_start_date exists
311: SELECT 1 INTO l_count FROM DUAL
312: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
313: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
314: AND START_ORG_ID=P_START_ORG_ID
315: AND END_ORG_ID=P_END_ORG_ID

Line 341: SELECT 1 INTO l_count FROM DUAL

337: END;
338: END;
339: */
340: BEGIN
341: SELECT 1 INTO l_count FROM DUAL
342: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
343: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
344: AND START_ORG_ID=P_START_ORG_ID
345: AND END_ORG_ID=P_END_ORG_ID

Line 412: SELECT 1 INTO l_count FROM DUAL

408: -- overlap check
409: IF p_end_date IS NULL THEN
410: -- All transaction flows with same attributes should have end date less then the start date of this transaction
411: BEGIN
412: SELECT 1 INTO l_count FROM DUAL
413: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
414: WHERE START_ORG_ID=P_START_ORG_ID
415: AND HEADER_ID <> NVL(P_HEADER_ID,-999)
416: AND END_ORG_ID=P_END_ORG_ID

Line 442: SELECT 1 INTO l_count FROM DUAL

438: -- If a Inter-company Transaction Flow with same attributes and NULL End Date exists
439: -- Then new Inter-company Transaction Flow can only be
440: -- defined for End Date less then
441: -- the Start Date of existing Inter-company Transaction Flow
442: SELECT 1 INTO l_count FROM DUAL
443: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
444: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
445: AND START_ORG_ID=P_START_ORG_ID
446: AND END_ORG_ID=P_END_ORG_ID

Line 466: SELECT 1 INTO l_count FROM DUAL

462: BEGIN
463: -- End Date should be less than the Start Date of any other Inter-company
464: -- Transaction Flow with same attributes and Start Date greater than the
465: -- Start Date of current Inter-company Transaction Flow
466: SELECT 1 INTO l_count FROM DUAL
467: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
468: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
469: AND START_ORG_ID=P_START_ORG_ID
470: AND END_ORG_ID=P_END_ORG_ID

Line 498: SELECT 1 INTO l_count FROM DUAL

494: END IF;--p_end_date
495:
496: */
497: BEGIN
498: SELECT 1 INTO l_count FROM DUAL
499: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
500: WHERE HEADER_ID <> NVL(P_HEADER_ID,-999)
501: AND START_ORG_ID=P_START_ORG_ID
502: AND END_ORG_ID=P_END_ORG_ID

Line 699: SELECT 1 INTO l_count FROM DUAL

695: x_return_code:=0;
696: -- If a transaction flow with NULL end date exists then no other
697: --transaction flow can be created
698: BEGIN
699: SELECT 1 INTO l_count FROM DUAL
700: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
701: WHERE START_ORG_ID=P_START_ORG_ID
702: AND END_ORG_ID=P_END_ORG_ID
703: AND FLOW_TYPE=P_FLOW_TYPE

Line 726: SELECT 1 INTO l_count FROM DUAL

722:
723: -- if no trx flow with same attributes and end_date greater than sysdate or null exists
724: -- then default the start date to sysdate
725: BEGIN
726: SELECT 1 INTO l_count FROM DUAL
727: WHERE EXISTS (SELECT HEADER_ID FROM MTL_TRANSACTION_FLOW_HEADERS
728: WHERE START_ORG_ID=P_START_ORG_ID
729: AND END_ORG_ID=P_END_ORG_ID
730: AND FLOW_TYPE=P_FLOW_TYPE

Line 1485: select 1 into l_count1 from dual where exists

1481: Then
1482: If(P_NEW_ACCOUNTING_FLAG ='Y')
1483: Then
1484: Begin
1485: select 1 into l_count1 from dual where exists
1486: (
1487: select ship_organization_id from mtl_intercompany_parameters
1488: where ship_organization_id=l_lines_table(l_index).from_org_id
1489: and sell_organization_id=l_lines_table(l_index).to_org_id