APPS.QA_SS_CORE SQL Statements

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

Line: 49

		Select prompt
		From QA_CHARS
		WHERE char_id = X_char_id;

Line: 77

		SELECT entity_type
		FROM WIP_ENTITIES
		WHERE WIP_ENTITY_ID = X_Wip_Entity_Id;

Line: 87

		SELECT wip_entity_id
		FROM WIP_DISCRETE_JOBS_ALL_V
		WHERE WIP_ENTITY_ID = X_Wip_Entity_Id;

Line: 165

        select  mck.concatenated_segments,
                mck.category_id
        from    mtl_item_categories mic, mtl_categories_kfv mck
        where   mic.organization_id = p_org_id
        and     mic.category_id = mck.category_id
        and     mic.inventory_item_id =p_item_id
        and     mic.category_set_id = p_category_set_id;

Line: 214

selectbox IN qa_ss_const.var30_table DEFAULT qa_ss_const.def30_tab,
p_col1 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col2 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col3 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col4 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col5 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col6 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col7 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col8 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col9 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col10 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col11 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col12 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col13 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col14 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col15 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col16 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col17 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col18 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col19 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col20 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col21 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col22 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col23 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col24 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col25 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col26 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col27 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col28 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col29 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col30 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col31 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col32 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col33 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col34 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col35 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col36 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col37 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col38 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col39 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col40 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col41 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col42 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col43 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col44 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col45 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col46 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col47 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col48 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col49 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col50 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col51 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col52 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col53 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col54 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col55 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col56 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col57 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col58 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col59 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col60 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col61 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col62 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col63 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col64 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col65 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col66 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col67 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col68 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col69 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col70 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col71 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col72 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col73 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col74 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col75 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col76 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col77 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col78 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col79 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col80 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col81 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col82 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col83 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col84 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col85 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col86 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col87 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col88 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col89 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col90 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col91 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col92 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col93 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col94 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col95 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col96 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col97 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col98 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col99 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col100 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col101 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col102 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col103 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col104 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col105 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col106 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col107 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col108 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col109 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col110 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col111 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col112 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col113 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col114 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col115 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col116 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col117 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col118 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col119 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col120 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col121 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col122 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col123 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col124 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col125 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col126 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col127 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col128 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col129 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col130 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col131 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col132 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col133 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col134 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col135 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col136 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col137 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col138 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col139 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col140 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col141 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col142 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col143 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col144 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col145 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col146 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col147 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col148 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col149 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col150 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col151 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col152 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col153 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col154 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col155 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col156 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col157 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col158 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col159 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
p_col160 IN qa_ss_const.Eqr_Array DEFAULT qa_ss_const.def_array,
hid_planid IN NUMBER DEFAULT NULL,
orgz_id IN NUMBER DEFAULT NULL,
txn_num IN NUMBER DEFAULT NULL,
po_agent_id IN NUMBER DEFAULT NULL,
x_source_id IN NUMBER DEFAULT NULL,
x_item_id IN NUMBER DEFAULT NULL,
x_po_header_id IN NUMBER DEFAULT NULL)
IS
    orgz_ex EXCEPTION;

Line: 390

    rows_selected BOOLEAN := FALSE;

Line: 404

	SELECT qpc.char_id
	FROM qa_plan_chars qpc
	where qpc.plan_id = hid_planid
	AND qpc.enabled_flag = 1
	ORDER BY qpc.prompt_sequence;

Line: 482

        SAVEPOINT start_inserting;

Line: 494

             if  (  NOT selectbox.Exists(K) ) Then

                -- if ( selectbox(K) = 'N')  THEN
                        -- htp.p('row ' || to_char(K)|| 'top level filtered'); htp.nl;

Line: 675

                        r := to_number(selectbox(K));

Line: 677

                        rows_selected := TRUE;

Line: 929

        If (rows_selected = FALSE) Then
                htp.p(fnd_message.get_string('QA', 'QA_SS_NO_CHANGES')); -- New code

Line: 934

                fnd_message.set_name('QA', 'QA_SS_INSERT_OK');

Line: 941

            htp.p(fnd_message.get_string('QA', 'QA_SS_INSERT_NOT_OK'));

Line: 942

            Rollback to start_inserting; -- rollback any inserts issued

Line: 1027

		select qpc.prompt_sequence, qc.char_id, qc.name, NVL(qc.developer_name, qc.name) AS cname, qc.sql_validation_string, qpc.prompt, qc.display_length, qpc.default_value,
qpc.enabled_flag, qc.data_entry_hint
		from qa_plan_chars qpc, qa_chars qc
		where qpc.plan_id = plan_id_i
		AND qpc.char_id = qc.char_id
		AND qpc.enabled_flag = 1
		ORDER BY qpc.prompt_sequence;

Line: 1057

        select qp.name into plan_name_i
 		from qa_plans qp
		where qp.plan_id = plan_id_i;

Line: 1123

              htp.tableData(cvalue=>''||'Select'||'',
						calign=>'LEFT', cattributes=>'valign=bottom bgcolor="#336699"');

Line: 1184

            htp.tableData( htf.formCheckbox(cname=>'selectbox',
                                            cvalue=>to_char(rows)));

Line: 1211

							dv_arr(cols),'onChange="document.RSMDF.selectbox['
                                    || to_char(rows-1) || '].value=''Y''"  onFocus="window.status='''||dhint_tab(cols)||'''"' ),
                             calign=>'CENTER',
							crowspan=>'1',
							cattributes=>'VALIGN="CENTER"');

Line: 1220

							dv_arr(cols),'onChange="document.RSMDF.selectbox['
                                    || to_char(rows-1) || '].checked=true"  onFocus="window.status='''||dhint_tab(cols)||'''"' ),
                             calign=>'CENTER',
							crowspan=>'1',
							cattributes=>'VALIGN="CENTER"');

Line: 1325

    Select count(1) INTO coll_trigg
    From qa_txn_collection_triggers qtct
    WHERE qtct.transaction_number = txnumber
    AND qtct.collection_trigger_id = cid;

Line: 1364

	SELECT values_exist_flag, sql_validation_string INTO inlist_exists,sql_val_st
	FROM qa_chars
	WHERE char_id = cid;

Line: 1441

	SELECT name
	FROM QA_PLANS
	WHERE plan_id = plan_id_i ;

Line: 1783

	select qpc.prompt_sequence, qc.char_id, qc.name, qc.prompt, qpc.enabled_flag
	from qa_plan_chars qpc, qa_chars qc
	where qpc.plan_id = plan_id_i
	AND qpc.char_id = qc.char_id
	AND qpc.enabled_flag = 1
	ORDER BY qpc.prompt_sequence;

Line: 1805

	select qp.name into plan_name_i
	from qa_plans qp
	where qp.plan_id = plan_id_i;

Line: 3422

	SELECT qpt.Plan_transaction_id,
		qpt.Plan_id,
		qc.char_id,
        qc.dependent_char_id,
		qc.datatype,
		qpct.Operator,
		qpct.Low_Value,
		qpct.High_Value
	FROM qa_plan_collection_triggers qpct,
		qa_plan_transactions qpt,
		qa_plans_val_v qp,
        qa_chars qc,
		qa_txn_collection_triggers qtct
	WHERE qpt.Plan_ID = qp.Plan_ID
	AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID
        AND qpct.Collection_Trigger_ID = qtct.Collection_Trigger_ID(+)
        AND qpct.Collection_Trigger_ID = qc.char_id(+)
	AND qpt.TRANSACTION_NUMBER = x_txn_number
        AND qtct.TRANSACTION_NUMBER(+) = x_txn_number
        AND qp.ORGANIZATION_ID = x_organization_id
        AND qpt.enabled_flag = 1
ORDER BY qpt.plan_transaction_id;

Line: 3633

            Select qp.name, qp.description, fcl.meaning
            from qa_plans qp, fnd_common_lookups fcl
            where qp.plan_id = X_Pid
            and qp.plan_type_code = fcl.lookup_code
            and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'
            Order By qp.name;

Line: 3947

	SELECT name
	FROM QA_PLANS
	WHERE plan_id = plan_id_i ;

Line: 4166

		SELECT qpt.plan_id, qpt.plan_transaction_id
		FROM QA_PLAN_TRANSACTIONS QPT
		Where qpt.plan_id = Pid
		and qpt.transaction_number = Txn_Num;

Line: 4177

		--SELECT 1
		--from qa_plan_collection_triggers qpct
		--where qpct.plan_transaction_id = c_plan_txn_id
		--and qpct.collection_trigger_id = 11;

Line: 4290

		SELECT qpt.plan_id
		FROM QA_PLAN_TRANSACTIONS QPT
		Where qpt.plan_id = Pid
		and qpt.transaction_number = 100;

Line: 4304

    Ctx.delete();

Line: 4381

		SELECT qpt.plan_id
		FROM QA_PLAN_TRANSACTIONS QPT
		Where qpt.plan_id = Pid
		and qpt.transaction_number = 110;

Line: 4395

    Ctx.delete();

Line: 4432

	SELECT qpt.Plan_transaction_id,
		qpt.Plan_id,
		qc.char_id,
        qc.dependent_char_id,
		qc.datatype,
		qpct.Operator,
		qpct.Low_Value,
		qpct.High_Value
	FROM qa_plan_collection_triggers qpct,
		qa_plan_transactions qpt,
		qa_plans qp,
        qa_chars qc,
		qa_txn_collection_triggers qtct
	WHERE qp.Plan_ID = x_Pid
	AND qpt.Plan_ID = qp.Plan_ID
	AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID
        AND qpct.Collection_Trigger_ID = qtct.Collection_Trigger_ID(+)
        AND qpct.Collection_Trigger_ID = qc.char_id(+)
	AND qpt.TRANSACTION_NUMBER = x_txn_number
        AND qtct.TRANSACTION_NUMBER(+) = x_txn_number
        AND qp.ORGANIZATION_ID = x_organization_id
        AND qpt.enabled_flag = 1
ORDER BY qpt.plan_transaction_id;

Line: 4564

	SELECT Release_Num
	FROM Po_Releases_All
	WHERE Po_Release_Id = po_rel_id;

Line: 4585

	Select AGENT_ID
	From 	PO_HEADERS_ALL
	Where	PO_HEADER_ID = po_hdr_id;

Line: 4590

	Select AGENT_ID
	From	PO_RELEASES_ALL
	Where	PO_RELEASE_ID = po_rel_id;

Line: 4619

        SELECT 1
        FROM   qa_txn_collection_triggers qtct
        WHERE  qtct.transaction_number = txn_number
        AND    qtct.collection_trigger_id = element_id;

Line: 4648

		SELECT entity_type
		FROM WIP_ENTITIES
		WHERE WIP_ENTITY_ID = X_Wip_Entity_Id;

Line: 4658

		SELECT wip_entity_id
		FROM WIP_DISCRETE_JOBS_ALL_V
		WHERE WIP_ENTITY_ID = X_Wip_Entity_Id;