APPS.ICX_POR_EXT_TEST dependencies on ICX_POR_EXT_ITEM

Line 3325: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND

3321: INTO p_rt_item_id
3322: FROM icx_cat_items_b i
3323: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3324: org_id = p_org_id)
3325: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3326: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3327: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3328: supplier_id = p_supplier_id)
3329: AND (supplier IS NULL AND p_supplier IS NULL OR

Line 3326: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =

3322: FROM icx_cat_items_b i
3323: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3324: org_id = p_org_id)
3325: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3326: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3327: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3328: supplier_id = p_supplier_id)
3329: AND (supplier IS NULL AND p_supplier IS NULL OR
3330: supplier = p_supplier)

Line 3327: ICX_POR_EXT_ITEM.NULL_NUMBER OR

3323: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3324: org_id = p_org_id)
3325: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3326: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3327: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3328: supplier_id = p_supplier_id)
3329: AND (supplier IS NULL AND p_supplier IS NULL OR
3330: supplier = p_supplier)
3331: AND (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR

Line 3409: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND

3405: INTO xResult
3406: FROM icx_cat_items_b i
3407: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3408: org_id = p_org_id)
3409: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3410: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3411: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3412: supplier_id = p_supplier_id)
3413: AND (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR

Line 3410: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =

3406: FROM icx_cat_items_b i
3407: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3408: org_id = p_org_id)
3409: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3410: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3411: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3412: supplier_id = p_supplier_id)
3413: AND (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR
3414: supplier_part_num = p_supplier_part_num)

Line 3411: ICX_POR_EXT_ITEM.NULL_NUMBER OR

3407: WHERE (org_id IS NULL AND p_org_id IS NULL OR
3408: org_id = p_org_id)
3409: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3410: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3411: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3412: supplier_id = p_supplier_id)
3413: AND (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR
3414: supplier_part_num = p_supplier_part_num)
3415: AND (internal_item_id IS NULL AND p_internal_item_id IS NULL OR

Line 3484: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND

3480: AND language = p_language
3481: AND item_source_type = p_item_source_type
3482: AND search_type = p_search_type
3483: AND primary_category_name = p_primary_category_name
3484: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3485: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3486: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3487: supplier_id = p_supplier_id)
3488: AND (supplier IS NULL AND p_supplier IS NULL OR

Line 3485: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =

3481: AND item_source_type = p_item_source_type
3482: AND search_type = p_search_type
3483: AND primary_category_name = p_primary_category_name
3484: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3485: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3486: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3487: supplier_id = p_supplier_id)
3488: AND (supplier IS NULL AND p_supplier IS NULL OR
3489: supplier = p_supplier)

Line 3486: ICX_POR_EXT_ITEM.NULL_NUMBER OR

3482: AND search_type = p_search_type
3483: AND primary_category_name = p_primary_category_name
3484: AND (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
3485: NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
3486: ICX_POR_EXT_ITEM.NULL_NUMBER OR
3487: supplier_id = p_supplier_id)
3488: AND (supplier IS NULL AND p_supplier IS NULL OR
3489: supplier = p_supplier)
3490: AND (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR