DBA Data[Home] [Help]

APPS.AME_ATTRIBUTE_USAGES_API dependencies on AME_ITEM_CLASS_USAGES

Line 532: AME_ITEM_CLASS_USAGES ICLU

528: ) is
529: cursor CSR_GET_LINE_ITEM_CLASS_QUERY is
530: select ICLU.ITEM_ID_QUERY
531: from AME_ITEM_CLASSES ICLS,
532: AME_ITEM_CLASS_USAGES ICLU
533: where ICLU.APPLICATION_ID = X_APPLICATION_ID
534: and ICLS.ITEM_CLASS_ID = ICLU.ITEM_CLASS_ID
535: and ICLS.NAME = ame_util.lineitemitemclassname
536: and sysdate between ICLS.START_DATE and nvl(ICLS.END_DATE - (1/86400), sysdate)

Line 809: -- ame_item_class_usages

805: X_QUERY_STRING_OUT);
806: elsif (instrb(X_QUERY_STRING, ':lineItemIdList', -1) > 0) and
807: (X_LINE_ITEM_ID_QUERY is null) then
808: -- when 11510 patch is already applied, get LINE_ITEM_ID_QUERY from
809: -- ame_item_class_usages
810: GET_LINE_ITEM_CLASS_QUERY(X_APPLICATION_ID,
811: X_LINE_ITEM_ID_QUERY);
812: if X_LINE_ITEM_ID_QUERY is not null then
813: QUERY_STRING_VALIDATION(