APPS.PO_ASL_SV dependencies on PO_ASL_STATUS_RULES_V

Line 108: PO_ASL_STATUS_RULES_V

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
112: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

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 122: PO_ASL_STATUS_RULES_V

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
126: FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL, PO_ASL_STATUS_RULES_V ASR

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 137: PO_ASL_STATUS_RULES_V

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
141:

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