APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_PARAMETERS

Line 1891: from mtl_parameters

1887:
1888:
1889: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
1890: SELECT stock_locator_control_code
1891: from mtl_parameters
1892: where organization_id = p_organization_id;
1893:
1894: CURSOR get_si_locator_control_code ( p_organization_id NUMBER,
1895: p_secondary_inventory_name VARCHAR2 ) IS

Line 2085: FROM mtl_parameters mp,wip_parameters wp

2081: -- moved code above insert_transactions_header
2082: IF l_costing_method = -1 THEN
2083: SELECT primary_cost_method,decode(auto_compute_final_completion,1,'Y','N')
2084: INTO l_costing_method,lc_n_final_completion_flag
2085: FROM mtl_parameters mp,wip_parameters wp
2086: WHERE mp.organization_id = l_transactions_interface_rec.organization_id
2087: AND wp.organization_id = l_transactions_interface_rec.organization_id;
2088: END IF;
2089: l_transactions_interface_rec.final_completion_flag := lc_n_final_completion_flag;

Line 2130: FROM mtl_parameters mp,wip_parameters wp

2126: -- moved code above insert_transactions_header
2127: IF l_costing_method = -1 THEN
2128: SELECT primary_cost_method,decode(auto_compute_final_completion,1,'Y','N')
2129: INTO l_costing_method,lc_n_final_completion_flag
2130: FROM mtl_parameters mp,wip_parameters wp
2131: WHERE mp.organization_id = l_transactions_interface_rec.organization_id
2132: AND wp.organization_id = l_transactions_interface_rec.organization_id;
2133: END IF;
2134: l_transactions_interface_rec.final_completion_flag := lc_n_final_completion_flag;

Line 2173: FROM mtl_parameters mp,wip_parameters wp

2169: -- moved code above insert_transactions_header
2170: IF l_costing_method = -1 THEN
2171: SELECT primary_cost_method,decode(auto_compute_final_completion,1,'Y','N')
2172: INTO l_costing_method,lc_n_final_completion_flag
2173: FROM mtl_parameters mp,wip_parameters wp
2174: WHERE mp.organization_id = l_transactions_interface_rec.organization_id
2175: AND wp.organization_id = l_transactions_interface_rec.organization_id;
2176: END IF;
2177: l_transactions_interface_rec.final_completion_flag := lc_n_final_completion_flag;

Line 2902: SELECT stock_locator_control_code from mtl_parameters

2898: CURSOR get_mtl_header_id IS
2899: SELECT mtl_material_transactions_s.nextval from dual;
2900:
2901: CURSOR get_org_locator_control_code(p_organization_id NUMBER) IS
2902: SELECT stock_locator_control_code from mtl_parameters
2903: where organization_id = p_organization_id;
2904:
2905: CURSOR get_si_locator_control_code ( p_organization_id NUMBER,
2906: p_secondary_inventory_name VARCHAR2 ) IS

Line 8285: MTL_PARAMETERS MP

8281: BOM_RESOURCES BR,
8282: wip_operations wo,
8283: WIP_DISCRETE_JOBS wdj,
8284: per_all_people_f papf,
8285: MTL_PARAMETERS MP
8286: WHERE CRJX.wip_entity_id = p_wip_entity_id
8287: AND WO.operation_seq_num = p_operation_seq_num
8288: AND CRJX.wip_entity_id = WOR.wip_entity_id
8289: AND WOR.WIP_ENTITY_ID = WE.WIP_ENTITY_ID

Line 8721: MTL_PARAMETERS MP

8717: BOM_RESOURCES BR,
8718: wip_operations wo,
8719: WIP_DISCRETE_JOBS wdj,
8720: per_all_people_f papf,
8721: MTL_PARAMETERS MP
8722: WHERE CRJX.wip_entity_id = p_wip_entity_id
8723: AND WO.operation_seq_num = p_operation_seq_num
8724: AND WOR.RESOURCE_ID = p_resource_id
8725: AND CRJX.wip_entity_id = WOR.wip_entity_id