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.

[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_CONFIG_DETAILS_V

Line 835: p_component_code IN cz_config_details_v.component_code%TYPE,

831: ------procedure that logs a delta message to
832: ------cz_config_messages
833: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
834: p_organization_id IN mtl_system_items.organization_id%TYPE ,
835: p_component_code IN cz_config_details_v.component_code%TYPE,
836: p_current_quantity IN NUMBER,
837: p_new_quantity IN NUMBER,
838: p_config_hdr IN NUMBER,
839: p_config_rev IN NUMBER,

Line 904: l_new_component_code cz_config_details_v.component_code%TYPE;

900: l_prev_qty NUMBER := 0;
901: l_description mtl_system_items.description%TYPE;
902: l_new_item cz_config_items.config_item_id%TYPE:= 0;
903: l_new_rev cz_config_hdrs.config_rev_nbr%TYPE := 0;
904: l_new_component_code cz_config_details_v.component_code%TYPE;
905: l_new_qty NUMBER := 0;
906: l_new_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
907: l_new_organization_id mtl_system_items.organization_id%TYPE;
908: v_valid_config VARCHAR2(30);

Line 927: l_prev_component_code cz_config_details_v.component_code%TYPE;

923: l_config_true_tag VARCHAR2(30) := 'true';
924: l_config_false_tag VARCHAR2(30) := 'false';
925: l_prev_inventory_item_id mtl_system_items.inventory_item_id%TYPE;
926: l_prev_organization_id mtl_system_items.organization_id%TYPE;
927: l_prev_component_code cz_config_details_v.component_code%TYPE;
928:
929: CURSOR c_config_delta (p_old_hdr NUMBER,p_old_rev NUMBER,p_new_hdr NUMBER,p_new_rev NUMBER)
930: IS select config_rev_nbr,config_item_id,quantity,
931: component_code,inventory_item_id,organization_id

Line 932: from cz_config_details_v

928:
929: CURSOR c_config_delta (p_old_hdr NUMBER,p_old_rev NUMBER,p_new_hdr NUMBER,p_new_rev NUMBER)
930: IS select config_rev_nbr,config_item_id,quantity,
931: component_code,inventory_item_id,organization_id
932: from cz_config_details_v
933: where (config_hdr_id,config_item_id,quantity)
934: IN (
935: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
936: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev

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

931: component_code,inventory_item_id,organization_id
932: from cz_config_details_v
933: where (config_hdr_id,config_item_id,quantity)
934: IN (
935: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
936: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev
937: minus
938: select config_hdr_id,config_item_id,quantity from cz_config_details_v
939: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )

Line 938: select config_hdr_id,config_item_id,quantity from cz_config_details_v

934: IN (
935: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
936: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev
937: minus
938: select config_hdr_id,config_item_id,quantity from cz_config_details_v
939: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )
940: union
941: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
942: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev

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

937: minus
938: select config_hdr_id,config_item_id,quantity from cz_config_details_v
939: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev )
940: union
941: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
942: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev
943: minus
944: select config_hdr_id,config_item_id,quantity from cz_config_details_v
945: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev )

Line 944: select config_hdr_id,config_item_id,quantity from cz_config_details_v

940: union
941: (select config_hdr_id,config_item_id,quantity from cz_config_details_v
942: where config_hdr_id = p_new_hdr and config_rev_nbr = p_new_rev
943: minus
944: select config_hdr_id,config_item_id,quantity from cz_config_details_v
945: where config_hdr_id = p_old_hdr and config_rev_nbr = p_old_rev )
946: )
947: and config_rev_nbr IN (p_old_rev, p_new_rev)
948: ORDER BY config_item_id,config_hdr_id,config_rev_nbr;