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.PO_ASL_SV dependencies on PO_APPROVED_SUPPLIER_LIS_VAL_V

Line 89: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR

85: -- 4_DISTRIBUTOR_MFR_LINK
86: /*
87: commented the following as part of the performance fix for 1517028
88: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status
89: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES ASR
90: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
91: AND ASL.vendor_id = x_vendor_id
92: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
93: AND ( (ASL.item_id = x_item_id) OR

Line 107: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with

103: /*1517028 Breaking sql statement into three diffrent sql statements to
104: remove OR between checks for item_id and category id...never combine them...*/
105:
106: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
107: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
108: PO_ASL_STATUS_RULES_V
109: */
110:
111: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status

Line 112: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

108: PO_ASL_STATUS_RULES_V
109: */
110:
111: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status
112: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR
113: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
114: AND ASL.vendor_id = x_vendor_id
115: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
116: AND ASL.item_id = x_item_id

Line 121: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with

117: AND ASL.asl_status_id = ASR.status_id
118: AND ASR.business_rule = x_action;
119:
120: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
121: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
122: PO_ASL_STATUS_RULES_V
123: */
124: IF x_asl_status IS NULL THEN
125: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status

Line 126: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

122: PO_ASL_STATUS_RULES_V
123: */
124: IF x_asl_status IS NULL THEN
125: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status
126: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR
127: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
128: AND ASL.vendor_id = x_vendor_id
129: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
130: AND ASL.category_id = x_category_id

Line 136: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with

132: AND ASR.business_rule = x_action;
133: END IF;
134:
135: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
136: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
137: PO_ASL_STATUS_RULES_V
138: */
139:
140: IF x_asl_status IS NULL THEN

Line 147: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

143: -- Take out of IN statement to force using index,
144: -- avoiding full-table scan
145: /*
146: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_status
147: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR
148: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
149: AND ASL.vendor_id = x_vendor_id
150: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
151: AND ASL.category_id in (SELECT MIC.category_id

Line 162: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

158: */
159: for v_category in c_category_ids(x_item_id, x_ship_to_org) loop
160:
161: SELECT sum(decode(ASR.allow_action_flag, 'Y', 1, -100)) INTO x_asl_s
162: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR
163: WHERE ASL.using_organization_id IN (nvl(x_ship_to_org,-1), -1)
164: AND ASL.vendor_id = x_vendor_id
165: AND nvl(ASL.vendor_site_id, nvl(x_vendor_site_id,-1)) = nvl(x_vendor_site_id,-1)
166: AND ASL.category_id = v_category.category_id