APPS.WIP_PENDING_TXNS SQL Statements

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

Line: 38

	SELECT	 WIP_CONSTANTS.YES
	INTO	 P_RESOURCES_CHARGED
	FROM	 DUAL
	WHERE EXISTS (SELECT 'X'
                        FROM WIP_OPERATION_RESOURCES
                       WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
                         AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
                         AND APPLIED_RESOURCE_UNITS <> 0);

Line: 56

	SELECT	 WIP_CONSTANTS.YES
	INTO	 P_MATERIAL_ISSUED
	FROM	 DUAL
	WHERE EXISTS (SELECT 'X'
                        FROM WIP_REQUIREMENT_OPERATIONS
                       WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
                         AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
                         AND QUANTITY_ISSUED <> 0);

Line: 73

	SELECT	WIP_CONSTANTS.YES
	INTO	P_MTL_TXNS_TEMP
	FROM	DUAL
	WHERE EXISTS (SELECT 1
			FROM MTL_MATERIAL_TRANSACTIONS_TEMP
		       WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
			 AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
			 AND TRANSACTION_SOURCE_TYPE_ID = 5);

Line: 90

        SELECT  WIP_CONSTANTS.YES
        INTO    P_UNCOSTED_MTL_TXNS
        FROM    DUAL
        WHERE EXISTS (SELECT 1
                        FROM MTL_MATERIAL_TRANSACTIONS
                       WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
                         AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
			 AND COSTED_FLAG IN ('N','E')
                         AND TRANSACTION_SOURCE_TYPE_ID = 5);

Line: 108

        SELECT  WIP_CONSTANTS.YES
        INTO    P_PO_REQ_LINES
        FROM    DUAL
        WHERE EXISTS (SELECT 1
                        FROM PO_REQUISITION_LINES_ALL
                       WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
			 AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);

Line: 124

        SELECT  WIP_CONSTANTS.YES
        INTO    P_PO_REQ_INTERFACE
        FROM    DUAL
        WHERE EXISTS (SELECT 1
                        FROM PO_REQUISITIONS_INTERFACE_ALL
                       WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
			 AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);

Line: 140

        SELECT  WIP_CONSTANTS.YES
        INTO    P_MOVE_TXN_INTERFACE
        FROM    DUAL
        WHERE EXISTS (SELECT 1
                        FROM WIP_MOVE_TXN_INTERFACE
                       WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
			 AND ORGANIZATION_ID = P_ORGANIZATION_ID);

Line: 156

        SELECT  WIP_CONSTANTS.YES
        INTO    P_COST_TXN_INTERFACE
        FROM    DUAL
        WHERE EXISTS (SELECT 1
                        FROM WIP_COST_TXN_INTERFACE
                       WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
			 AND ORGANIZATION_ID = P_ORGANIZATION_ID);