eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_CF_API dependencies on MTL_SYSTEM_ITEMS

Line 844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id

840: END check_if_new_revision;
841:
842: -----------------------------------------------
843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)

Line 845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

841:
842: -----------------------------------------------
843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS

Line 846: p_organization_id IN mtl_system_items.organization_id%TYPE,

842: -----------------------------------------------
843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:

Line 847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,

843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:
851: BEGIN

Line 848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)

844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:
851: BEGIN
852: ----get description,itemname from mtl_system_items

Line 852: ----get description,itemname from mtl_system_items

848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:
851: BEGIN
852: ----get description,itemname from mtl_system_items
853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id

Line 855: FROM mtl_system_items_kfv

851: BEGIN
852: ----get description,itemname from mtl_system_items
853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:

Line 856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id

852: ----get description,itemname from mtl_system_items
853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:
860: --------------------------------------------------

Line 857: AND mtl_system_items_kfv.organization_id = p_organization_id;

853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:
860: --------------------------------------------------
861: ------procedure that logs a delta message to

Line 863: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,

859:
860: --------------------------------------------------
861: ------procedure that logs a delta message to
862: ------cz_config_messages
863: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
864: p_organization_id IN mtl_system_items.organization_id%TYPE ,
865: p_component_code IN cz_config_details_v.component_code%TYPE,
866: p_current_quantity IN NUMBER,
867: p_new_quantity IN NUMBER,

Line 864: p_organization_id IN mtl_system_items.organization_id%TYPE ,

860: --------------------------------------------------
861: ------procedure that logs a delta message to
862: ------cz_config_messages
863: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
864: p_organization_id IN mtl_system_items.organization_id%TYPE ,
865: p_component_code IN cz_config_details_v.component_code%TYPE,
866: p_current_quantity IN NUMBER,
867: p_new_quantity IN NUMBER,
868: p_config_hdr IN NUMBER,

Line 874: l_description mtl_system_items_kfv.description%TYPE;

870: p_message_name IN fnd_new_messages.message_name%TYPE)
871:
872: IS
873:
874: l_description mtl_system_items_kfv.description%TYPE;
875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
876: v_OracleSequenceIncr NUMBER := 20;
877: l_msg_seq NUMBER := 0;
878: l_delta_message VARCHAR2(2000);

Line 875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

871:
872: IS
873:
874: l_description mtl_system_items_kfv.description%TYPE;
875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
876: v_OracleSequenceIncr NUMBER := 20;
877: l_msg_seq NUMBER := 0;
878: l_delta_message VARCHAR2(2000);
879:

Line 881: ----get description,itemname from mtl_system_items

877: l_msg_seq NUMBER := 0;
878: l_delta_message VARCHAR2(2000);
879:
880: BEGIN
881: ----get description,itemname from mtl_system_items
882: get_item_description_and_name (p_inventory_item_id,
883: p_organization_id,
884: l_description,
885: l_new_item_name);

Line 940: l_description mtl_system_items.description%TYPE;

936: v_output_cfg_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE := 0;
937: l_prev_item cz_config_items.config_item_id%TYPE := 0;
938: l_prev_rev cz_config_hdrs.config_rev_nbr%TYPE;
939: l_prev_qty NUMBER := 0;
940: l_description mtl_system_items.description%TYPE;
941: l_new_item cz_config_items.config_item_id%TYPE:= 0;
942: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
943: l_new_component_code cz_config_details_v.component_code%TYPE;
944: l_new_qty NUMBER := 0;

Line 945: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;

941: l_new_item cz_config_items.config_item_id%TYPE:= 0;
942: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
943: l_new_component_code cz_config_details_v.component_code%TYPE;
944: l_new_qty NUMBER := 0;
945: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
946: l_new_organization_id mtl_system_items.organization_id%TYPE;
947: v_valid_config VARCHAR2(30);
948: v_complete_config VARCHAR2(30);
949: v_parse_status VARCHAR2(1);

Line 946: l_new_organization_id mtl_system_items.organization_id%TYPE;

942: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
943: l_new_component_code cz_config_details_v.component_code%TYPE;
944: l_new_qty NUMBER := 0;
945: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
946: l_new_organization_id mtl_system_items.organization_id%TYPE;
947: v_valid_config VARCHAR2(30);
948: v_complete_config VARCHAR2(30);
949: v_parse_status VARCHAR2(1);
950: l_param_value VARCHAR2(3);

Line 964: l_prev_inventory_item_id mtl_system_items.inventory_item_id%TYPE;

960: l_qty_changed BOOLEAN := FALSE;
961: l_prev_count NUMBER := 0;
962: l_config_true_tag VARCHAR2(30) := 'true';
963: l_config_false_tag VARCHAR2(30) := 'false';
964: l_prev_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
965: l_prev_organization_id mtl_system_items.organization_id%TYPE;
966: l_prev_component_code cz_config_details_v.component_code%TYPE;
967:
968: CURSOR c_config_delta (p_old_hdr NUMBER,p_old_rev NUMBER,p_new_hdr NUMBER,p_new_rev NUMBER)

Line 965: l_prev_organization_id mtl_system_items.organization_id%TYPE;

961: l_prev_count NUMBER := 0;
962: l_config_true_tag VARCHAR2(30) := 'true';
963: l_config_false_tag VARCHAR2(30) := 'false';
964: l_prev_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
965: l_prev_organization_id mtl_system_items.organization_id%TYPE;
966: l_prev_component_code cz_config_details_v.component_code%TYPE;
967:
968: CURSOR c_config_delta (p_old_hdr NUMBER,p_old_rev NUMBER,p_new_hdr NUMBER,p_new_rev NUMBER)
969: IS select config_rev_nbr,config_item_id,quantity,

Line 2736: FROM mtl_system_items

2732: IF p_publication_id IS NULL THEN
2733: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
2734: BEGIN
2735: SELECT 1 INTO l_dummy
2736: FROM mtl_system_items
2737: WHERE inventory_item_id = p_inventory_item_id
2738: AND organization_id = p_organization_id
2739: AND bom_item_type = BOM_ITEM_TYPE_MODEL;
2740: EXCEPTION

Line 3992: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B

3988: dp_org_id IN VARCHAR2,
3989: p_inventory_item_id IN VARCHAR2) AS
3990:
3991: CURSOR C_GETMODELS(Org_ID NUMBER) IS
3992: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
3993: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
3994: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
3995: AND B.BOM_ITEM_TYPE=1
3996: AND A.ORGANIZATION_ID= Org_ID

Line 4095: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B

4091: dp_org_id IN VARCHAR2,
4092: p_inventory_item_id IN VARCHAR2) AS
4093:
4094: CURSOR C_GETMODELS(Org_ID NUMBER) IS
4095: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
4096: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
4097: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
4098: AND B.BOM_ITEM_TYPE=1
4099: AND A.ORGANIZATION_ID= Org_ID