APPS.FND_DOCUMENT_MANAGEMENT dependencies on FND_DM_PRODUCTS

Line 3585: from fnd_dm_nodes dmn, fnd_dm_products dmp

3581: dmn.product_id,
3582: dmp.product_name,
3583: dmp.vendor_name,
3584: dmp.version
3585: from fnd_dm_nodes dmn, fnd_dm_products dmp
3586: where dmn.product_id = dmp.product_id;
3587:
3588: rowcount number;
3589: att_tvalue varchar2(2000) default null;

Line 3793: from fnd_dm_nodes dmn, fnd_dm_products dmp

3789: dmn.product_id,
3790: dmp.product_name,
3791: dmp.vendor_name,
3792: dmp.version
3793: from fnd_dm_nodes dmn, fnd_dm_products dmp
3794: where dmn.product_id = dmp.product_id;
3795:
3796: begin
3797:

Line 3932: FROM fnd_dm_products

3928: PRODUCT_ID ,
3929: PRODUCT_NAME ,
3930: VENDOR_NAME ,
3931: VERSION
3932: FROM fnd_dm_products
3933: WHERE product_name like c_find_criteria
3934: ORDER BY product_name;
3935:
3936: BEGIN

Line 3945: FROM fnd_dm_products

3941: IF (p_titles_only = 'N') THEN
3942:
3943: SELECT COUNT(*)
3944: INTO l_row_count
3945: FROM fnd_dm_products
3946: WHERE product_name like p_find_criteria||'%';
3947:
3948: END IF;
3949:

Line 4093: FROM fnd_dm_products dmp, fnd_dm_nodes dmn

4089: ** get the attributes
4090: */
4091: SELECT dmn.connect_syntax, dmp.product_name, dmn.product_id
4092: INTO l_connect_syntax, l_product_name, l_product_id
4093: FROM fnd_dm_products dmp, fnd_dm_nodes dmn
4094: WHERE dmn.node_id = l_dm_node_id
4095: AND dmp.product_id = dmn.product_id;
4096:
4097: IF (l_product_id = 10) THEN