APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on DUAL

Line 1539: DUAL;

1535: po_headers_interface_s.NEXTVAL
1536: INTO
1537: l_interface_header_id
1538: FROM
1539: DUAL;
1540:
1541: l_transaction_date := l_global_rate_date;
1542:
1543: IF (l_valid_flag = 'G') AND (NVL(l_global_rate,-1) = -1)

Line 1834: -- if its not null that means item is tracked in dual units

1830: l_conv_qty := l_quantity;
1831: END IF;
1832:
1833: -- INVCONV retrive secondary unit of measure for the item
1834: -- if its not null that means item is tracked in dual units
1835: -- from the quantity
1836: IF l_secondary_quantity IS NOT NULL THEN
1837: OPEN cr_get_sec_uom;
1838: FETCH cr_get_sec_uom INTO l_secondary_uom;

Line 1952: FROM DUAL;

1948: END IF;
1949:
1950: SELECT PO_LINES_INTERFACE_S.NEXTVAL
1951: INTO l_interface_line_id
1952: FROM DUAL;
1953:
1954: /* Bug 7231720 If the Profile Option PO: Automatic Document Sourcing is set to "Yes" then
1955: the latest valid blanket must be picked even if the blanket is not present in the Approved
1956: Supplier List. There is no check for the presence of a record in the table po_asl_documents if

Line 2051: FROM DUAL;

2047: SELECT
2048: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL
2049: INTO
2050: l_dist_interface_header_id
2051: FROM DUAL;
2052:
2053: IF (l_debug = 1)
2054: THEN
2055: INV_LOG_UTIL.trace

Line 2115: FROM DUAL;

2111: ,DECODE(l_rate,-1,NULL,l_date))
2112: /* Bug fix 5373370 - new column addded to po_dist_interface - Start*/
2113: , TO_CHAR(l_dist_interface_header_id)
2114: /* Bug fix 5373370 - End */
2115: FROM DUAL;
2116:
2117:
2118: /* Bug 5373370 - Start */
2119: /* The distribution_interface_ref that is inserted into

Line 3731: FROM dual;

3727: /* Bug 11822877. Changed the sequence value from mtl_third_party_cp_s
3728: to be in synchronization with PO headers sequence */
3729: SELECT po_headers_interface_s.nextval
3730: INTO l_batch_id
3731: FROM dual;
3732:
3733: RETURN l_batch_id;
3734:
3735: IF (l_debug = 1)

Line 4562: select 1 into l_count from dual

4558: INV_CONSUMPTION_ADVICE_PROC.populate_po_line_id();
4559:
4560: /* Bug 14036045. Performance issue. Modified below query and checking whether record exists or not.*/
4561: begin
4562: select 1 into l_count from dual
4563: where exists(select /*+ no_unnest */ 1 from MTL_CONSUMPTION_TRANSACTIONS mct
4564: where consumption_processed_flag IN ('N', 'E')
4565: AND ( mct.batch_id = l_batch_id OR mct.batch_id IS NULL) AND NVL(net_qty,0) > 0
4566: and exists(select /*+ no_unnest */ 1 from MTL_MATERIAL_TRANSACTIONS mmt