DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on EAM_DIRECT_ITEM_RECS_V

Line 651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,

647: l_api_return_status NUMBER;
648: l_api_msg_count NUMBER;
649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,

Line 652: organization_id eam_direct_item_recs_v.organization_id%TYPE,

648: l_api_msg_count NUMBER;
649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,

Line 653: task_number eam_direct_item_recs_v.task_number%TYPE,

649: l_api_msg_data VARCHAR2(2000);
650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,

Line 654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,

650: TYPE DirectItemRec IS RECORD (
651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,

Line 655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,

651: wip_entity_id eam_direct_item_recs_v.wip_entity_id%TYPE,
652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,

Line 656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,

652: organization_id eam_direct_item_recs_v.organization_id%TYPE,
653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,

Line 657: description eam_direct_item_recs_v.description%TYPE,

653: task_number eam_direct_item_recs_v.task_number%TYPE,
654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,

Line 658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,

654: inventory_item_id eam_direct_item_recs_v.inventory_item_id%TYPE,
655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,

Line 659: unit_price eam_direct_item_recs_v.unit_price%TYPE,

655: direct_item_sequence_id eam_direct_item_recs_v.direct_item_sequence_id%TYPE,
656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,

Line 660: uom_code eam_direct_item_recs_v.uom_code%TYPE,

656: direct_item_type_id eam_direct_item_recs_v.direct_item_type_id%TYPE,
657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,

Line 661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,

657: description eam_direct_item_recs_v.description%TYPE,
658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,

Line 662: date_required eam_direct_item_recs_v.date_required%TYPE,

658: required_quantity eam_direct_item_recs_v.required_quantity%TYPE,
659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,

Line 663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,

659: unit_price eam_direct_item_recs_v.unit_price%TYPE,
660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,

Line 664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,

660: uom_code eam_direct_item_recs_v.uom_code%TYPE,
661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );

Line 665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,

661: purchasing_category_id eam_direct_item_recs_v.purchasing_category_id%TYPE,
662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:

Line 666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,

662: date_required eam_direct_item_recs_v.date_required%TYPE,
663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;

Line 667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,

663: auto_request_material eam_direct_item_recs_v.auto_request_material%TYPE,
664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
671: l_di_recs l_di_recs_type;

Line 668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );

664: suggested_vendor_id eam_direct_item_recs_v.suggested_vendor_id%TYPE,
665: suggested_vendor_name eam_direct_item_recs_v.suggested_vendor_name%TYPE,
666: suggested_vendor_site eam_direct_item_recs_v.suggested_vendor_site%TYPE,
667: suggested_vendor_phone eam_direct_item_recs_v.suggested_vendor_phone%TYPE,
668: suggested_vendor_item_num eam_direct_item_recs_v.suggested_vendor_item_num%TYPE );
669:
670: TYPE l_di_recs_type IS REF CURSOR RETURN DirectItemRec;
671: l_di_recs l_di_recs_type;
672: l_di_record l_di_recs%ROWTYPE;