[Home] [Help]
50: END IF;
51:
52: -- Have a different cursor instead of using the cursor for openOnlineItemChangeCursor
53: -- because since the category assignment has deleted, in this case we need to do an
54: -- outer join with mtl_item_categories and check if the po_category_id is null
55: -- and the row is present in icx_cat_items_ctx_hdrs_tlpm then we need to remove these
56: -- items from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp
57:
58: l_err_loc := 300;
97: mparams.master_organization_id
98: FROM mtl_system_items_b mi,
99: mtl_parameters mparams,
100: mtl_system_items_tl mitl,
101: mtl_item_categories mic,
102: mtl_units_of_measure muom,
103: financials_system_params_all fsp,
104: icx_por_category_data_sources catMap
105: WHERE mi.inventory_item_id = p_inventory_item_id
227: mparams.master_organization_id
228: FROM mtl_system_items_b mi,
229: mtl_parameters mparams,
230: mtl_system_items_tl mitl,
231: mtl_item_categories mic,
232: mtl_units_of_measure muom,
233: financials_system_params_all fsp,
234: icx_por_category_data_sources catMap
235: WHERE mi.inventory_item_id = p_inventory_item_id
361: FROM mtl_system_items_b mi,
362: mtl_parameters mparams,
363: mtl_item_bulkload_recs mbulk,
364: mtl_system_items_tl mitl,
365: mtl_item_categories mic,
366: mtl_units_of_measure muom,
367: financials_system_params_all fsp,
368: icx_por_category_data_sources catMap
369: WHERE mbulk.request_id = p_request_id
459: FROM mtl_system_items_b mi,
460: mtl_parameters mparams,
461: mtl_item_bulkload_recs mbulk,
462: mtl_system_items_tl mitl,
463: mtl_item_categories mic,
464: mtl_units_of_measure muom,
465: mtl_category_sets msets,
466: financials_system_params_all fsp,
467: icx_por_category_data_sources catMap
541: FROM mtl_system_items_b mi,
542: mtl_parameters mparams,
543: mtl_item_bulkload_recs mbulk,
544: mtl_system_items_tl mitl,
545: mtl_item_categories mic,
546: mtl_units_of_measure muom,
547: mtl_category_sets msets,
548: financials_system_params_all fsp,
549: icx_por_category_data_sources catMap
667: mparams.master_organization_id
668: FROM mtl_system_items_b mi,
669: mtl_parameters mparams,
670: mtl_system_items_tl mitl,
671: mtl_item_categories mic,
672: mtl_units_of_measure muom,
673: financials_system_params_all fsp,
674: icx_por_category_data_sources catMap
675: WHERE mi.inventory_item_id = mitl.inventory_item_id
788: mparams.master_organization_id
789: FROM mtl_system_items_b mi,
790: mtl_parameters mparams,
791: mtl_system_items_tl mitl,
792: mtl_item_categories mic,
793: mtl_units_of_measure muom,
794: financials_system_params_all fsp,
795: icx_por_category_data_sources catMap
796: WHERE mi.inventory_item_id = mitl.inventory_item_id
865: mparams.master_organization_id
866: FROM mtl_system_items_b mi,
867: mtl_parameters mparams,
868: mtl_system_items_tl mitl,
869: mtl_item_categories mic,
870: mtl_units_of_measure muom,
871: financials_system_params_all fsp,
872: icx_por_category_data_sources catMap
873: WHERE mi.inventory_item_id = mitl.inventory_item_id