APPS.AZW_REPORT dependencies on AZ_PRODUCT_FLOWS

Line 1069: * az_product_flows into the intermediate table if the process does

1065: * Private procedure. Called by product_report.
1066: * Populate product process hierarchies in the intermediate table.
1067: * Performs the following steps:
1068: * 1. Get all distinct processes for the given application id from
1069: * az_product_flows into the intermediate table if the process does
1070: * not exist in the table.
1071: * 2. Find all distinct parent ids for the processes found in Step 1.
1072: * 3. For each parent id in Step 2, get all distinct hierarchy ancestors
1073: * in az_groups_v into the intermediate table if the parent does not

Line 1086: FROM az_product_flows apf,

1082: TO_CHAR(ag.display_order, '0000')||'.'||apf.parent_id
1083: parent_node_id,
1084: meaning context_type_name,
1085: wav.description
1086: FROM az_product_flows apf,
1087: az_groups ag,
1088: wf_activities_vl wav,
1089: fnd_lookups fnd
1090: WHERE apf.application_id = p_application_id

Line 1104: FROM az_product_flows apf

1100: AND fnd.lookup_code = apf.context_type;
1101:
1102: CURSOR parents_cursor IS
1103: SELECT DISTINCT apf.parent_id
1104: FROM az_product_flows apf
1105: WHERE apf.application_id = p_application_id;
1106:
1107: v_exist_cnt NUMBER;
1108: v_locator NUMBER;