DBA Data[Home] [Help]

APPS.RCV_INSERT_RTI_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

    INSERT INTO RCV_TRANSACTIONS_INTERFACE (
         INTERFACE_TRANSACTION_ID       ,
         GROUP_ID			,
         LAST_UPDATE_DATE               ,
         LAST_UPDATED_BY                ,
         LAST_UPDATE_LOGIN              ,
         CREATION_DATE                  ,
         CREATED_BY                     ,
         TRANSACTION_TYPE               ,
         TRANSACTION_DATE               ,
         PROCESSING_STATUS_CODE         ,
         PROCESSING_MODE_CODE           ,
         TRANSACTION_STATUS_CODE        ,
         CATEGORY_ID                    ,
	 QUANTITY                       ,
         UNIT_OF_MEASURE                ,
         INTERFACE_SOURCE_CODE          ,
         ITEM_ID                        ,
         ITEM_DESCRIPTION               ,
         EMPLOYEE_ID                    ,
         AUTO_TRANSACT_CODE             ,
         SHIP_TO_LOCATION_ID            ,
         PRIMARY_QUANTITY               ,
         PRIMARY_UNIT_OF_MEASURE        ,
         RECEIPT_SOURCE_CODE            ,
         VENDOR_ID                      ,
         TO_ORGANIZATION_ID             ,
         ROUTING_HEADER_ID              ,
         SOURCE_DOCUMENT_CODE           ,
         PO_HEADER_ID                   ,
         PO_LINE_ID                     ,
         PO_LINE_LOCATION_ID            ,
         DESTINATION_TYPE_CODE          ,
         LOCATION_ID                    ,
         SUBINVENTORY                   ,
         DESTINATION_CONTEXT            ,
         SHIPMENT_HEADER_ID             ,
         SHIPMENT_LINE_ID               ,
	 ORG_ID) --
 VALUES (
         RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
         X_group_id,
         X_last_update_date,
         X_last_updated_by,
         X_last_update_login,
         X_creation_date,
         X_created_by,
         X_transaction_type,
         X_transaction_date,
         X_processing_status_code,
         X_processing_mode_code,
         X_transaction_status_code,
         X_category_id,
         X_quantity_shipped,
         X_unit_of_measure,
         X_interface_source_code,
         X_item_id,
         X_item_description,
         X_employee_id,
         X_auto_transact_code,
         X_ship_to_location_id,
         X_primary_quantity,
         X_primary_unit_of_measure,
         X_receipt_source_code,
         X_vendor_id,
         X_to_organization_id,
	 X_routing_header_id,
         X_source_document_code,
         X_po_header_id,
         X_po_line_id,
         X_po_line_location_id,
         X_destination_type_code,
         X_deliver_to_location_id,
         X_subinventory,
         X_destination_context,
         X_shipment_header_id,
         X_shipment_line_id,
	 p_operating_unit_id --
      );
Line: 140

END insert_into_rti;