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 CZ_CONFIG_DETAILS_V

Line 865: p_component_code IN cz_config_details_v.component_code%TYPE,

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,
869: p_config_rev IN NUMBER,

Line 943: l_new_component_code cz_config_details_v.component_code%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;
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);

Line 966: l_prev_component_code cz_config_details_v.component_code%TYPE;

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,
970: component_code,inventory_item_id,organization_id

Line 971: from cz_config_details_v

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,
970: component_code,inventory_item_id,organization_id
971: from cz_config_details_v
972: where (config_hdr_id,config_item_id,quantity)
973: IN (
974: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
975: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev

Line 974: (select config_hdr_id,config_item_id,quantity from cz_config_details_v

970: component_code,inventory_item_id,organization_id
971: from cz_config_details_v
972: where (config_hdr_id,config_item_id,quantity)
973: IN (
974: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
975: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev
976: minus
977: select config_hdr_id,config_item_id,quantity from cz_config_details_v
978: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )

Line 977: select config_hdr_id,config_item_id,quantity from cz_config_details_v

973: IN (
974: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
975: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev
976: minus
977: select config_hdr_id,config_item_id,quantity from cz_config_details_v
978: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )
979: union
980: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
981: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev

Line 980: (select config_hdr_id,config_item_id,quantity from cz_config_details_v

976: minus
977: select config_hdr_id,config_item_id,quantity from cz_config_details_v
978: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )
979: union
980: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
981: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev
982: minus
983: select config_hdr_id,config_item_id,quantity from cz_config_details_v
984: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev )

Line 983: select config_hdr_id,config_item_id,quantity from cz_config_details_v

979: union
980: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
981: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev
982: minus
983: select config_hdr_id,config_item_id,quantity from cz_config_details_v
984: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev )
985: )
986: and config_rev_nbr IN (p_old_rev, p_new_rev)
987: ORDER BY config_item_id,config_hdr_id,config_rev_nbr;